Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 28th, 2011

Steps to set / modify Global Setting for Query Studio: 1. Stop the Cognos 8|ReportNet server. 2. On the Cognos 8|ReportNet Server, go to the directory /c8|crn/templates/ps/async/ 3. Either create a n...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

suji  

 Profile Answers by suji Questions by suji

• Member Since Sep-2005 | Nov 7th, 2011

---

I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable full-text index, so indexer will parse the data and search only the text content while ignoring the HTML tags. We had been using blob to store the documents, with the new features have come out in the later versions, this seems to be best option. We are in the process of migrating one of the app to use varbinary and to take advantage of the search feature. There is another way of storing using filestrem. Here is a good read-up from MS . FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx Here is another old report from MS back in 2006 explains about using oldway of BLOG http://research.microsoft.com/apps/pubs/default.aspx?id=64525 There are multiple options for you, pick the best approach that matches your needs Thanks, Suji

suji

 Profile Answers by suji Questions by suji

• Nov 7th, 2011

I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable fu...

Improve Answer

suji

 Profile Answers by suji Questions by suji

• Jan 15th, 2012

From your SQL Server Management Studio, you open Object Explorer, go to your database where you want to load the data into, right click, then pick Tasks > Import Data. Select the options based on the excel file

Answer Question  Select Best Answer

interviewer ask.. can we replace where clause by group by clause

let say

select * from table_name where some_condition

so how we replace where clause by group by clause

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Feb 16th, 2012

As a basic rule of query building: 1. The WHERE clause should be used to limit the number of rows returned by or affected by the a SQL statement. 2. The GROUP BY clause is used to group a selec...

Answer Question  Select Best Answer

murali chennupati

• Jul 5th, 2014

From jobs->new->step->categories->ssis->select db->select the package & schedule.

Answer Question  Select Best Answer

In application supporter for .net, interviewer ask me how you support the application,but I could not answer properly. Please explain answer technically?

Ravi Sharma

• Jun 2nd, 2015

We provided end to end solutions. Taking the requirement from client side, analysis on that requirement. Providing the analysis documents. Starting developing part then testing and deployment.

Answer Question  Select Best Answer

Display employee name, designation, Dob who are born in the same year.

Emono ename Designation Dob
101 Raj Developer 24-06-1992
102 mahesh Engineer 15-06-1992
103 Rajesh Mechanic 02-02-1991
104 suresh Jr Engineer 01-01-1990

Afsar

• Oct 25th, 2017

TD QUERY:
SELECT EXTRACT (YEAR FROM DOB), ename, Designation, Dob
FROM TABLE TAB1
GROUP BY EXTRACT (YEAR FROM DOB)

Answer Question  Select Best Answer

prathima

• Nov 3rd, 2005

Ref cursor can be used to retrieve and return the multiple records

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 21st, 2005

We are using explicit cursor to retrieve multiple row

Answer Question  Select Best Answer

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Examples for Analytical functions in Sql Server 2005:AVG, COMPUTE, DENSE RANK, NTile, Over, RANK, Row Number, STDEV, SUM, VAR, VARP, WITH ROLLUP

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

Analytical Function:-  return the infornation that about the relative possition of record (ROW_NUMBER,Rank,DENSE_RANK) and  allow to campare with succesor and precedessors when the...

Answer Question  Select Best Answer

Genie_Cool

• Jun 1st, 2007

If we are speaking about SQL Server and Dynamic SQL, then the following is the answer.Some queries in SQL Server might be given during run-time as we may not know the table that we might use in the pr...

rahultripathi

 Profile Answers by rahultripathi Questions by rahultripathi

• Sep 22nd, 2005

In dynamic SQL method 4 in  queries(select ) there are variable number of column and bind variable . Other word we can say that until run time we don't how many bind varible there.   Exemple...

Answer Question  Select Best Answer

jayaprakash.raman

 Profile Answers by jayaprakash.raman Questions by jayaprakash.raman

• Apr 24th, 2007

Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy"...

sm

• Nov 9th, 2005

In database table design we are providing Primary key and Foreign keys.And according to primary and Foreign keys tables are functionaly dependent on each other.

Answer Question  Select Best Answer

starmile

 Profile Answers by starmile Questions by starmile

• Jan 2nd, 2006

View is a logical partition of one or more table in horizontally(by putting condition) or vertically (by including selected columns). View can be used to update table, provides sec...

SankaraNarayanan

• Oct 3rd, 2005

View is the only part of existing table(Collection Cols) and we have to collect the no of col from table and we get  one view.The Max no.of col in view as 1024.

Answer Question  Select Best Answer

jannani

 Profile Answers by jannani Questions by jannani

• May 12th, 2009

SQL profiler is a graphical tool that allows system administrator to monitor in an instance of the SQL Server.Use of SQL Profiler:Monitor the performance of an instance of SQL Server.Debug Transact-SQ...

ak

• Nov 29th, 2005

It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuni...

Answer Question  Select Best Answer

Deepak

• Jan 1st, 2007

Index is used for the fast retrieval of data from the table. there are two types of indecs Clustered and Non clustered. Cluster index is created on primary key and it can be only on per table where as...

Phaneesh

• Feb 1st, 2006

Indexes are useful for maintaining unique values in a column, since the database can easily search the index to see if an incoming value already exists. Primary keys are always indexed for this r...

Answer Question  Select Best Answer

Yogesh Srivastava

• Jun 27th, 2006

Hi Your can try thisSELECT? CONVERT(varchar, GETDATE(), 103)In this example the GETDATE() will return your sql server?system date.and? the CONVERT is used to convert the date into the desired fomat...

rick

• Jun 24th, 2006

CREATE TABLE mytable ([Date] SMALLDATETIME)

Answer Question  Select Best Answer

smithsi

 Profile Answers by smithsi Questions by smithsi

• Jun 2nd, 2008

Set statistics io onset statistics time on

sapna

• Sep 20th, 2006

set showplan onset showplan_text on

Answer Question  Select Best Answer

Roopesh Nanaware

• Nov 3rd, 2006

CREATE PROCEDURE [usp_delete_Pataint_master] (@PataintID [int], @BranchID [int] )AS BEGIN SET NOCOUNT ON  BEGIN TRAN    DELETE [dbo].[P...

Baskar

• Aug 22nd, 2006

Rollback is used to Return the Qurey Statement of Execution After Begin StatementsEx : Begin Tran  Select * From Employee Order by Name  Delete From Employee Select * From Employee...

Answer Question  Select Best Answer

Ranjit

 Profile Answers by Ranjit Questions by Ranjit

• Dec 7th, 2006

http://msdn2.microsoft.com/en-us/library/ms175890.aspx

Jacx

• Oct 19th, 2006

The database can be modified using ALTER DATABASE with the syntaxALTER DATABASE database { ADD FILE < filespec > [ ,...n ] [ TO FILEGROUP filegroup_name ] | ADD LOG FILE < filespec > [ ,.....

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

suji  

 Profile Answers by suji Questions by suji

• Member Since Sep-2005 | Nov 6th, 2011

---

Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes. varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes. image variables store up to 2 gigabytes of data and are commonly used to store any type of data file. Rest of the data types are non-binary

suji

 Profile Answers by suji Questions by suji

• Nov 6th, 2011

Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary da...

krishnakumar

• Nov 3rd, 2006

The binary datatype is used for storing the images in the database.the non binary datatypes are integer,varchar etc

Improve Answer

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 18th, 2011

When you have to delete the records on primary key and foreigh key then there is problem will hapen as primary key violation at that time you have to provide delete rules when you create the tablesthose are1. on delete no action2. on delete cascade3. on delete set null4. on delete set default

caveatashish

 Profile Answers by caveatashish Questions by caveatashish

• Dec 14th, 2007

For primary key if that record is being refered by some other (Child Table)  sql server won't let you to delete that record.While creating relationship if you had mention "Dele...

Answer Question  Select Best Answer