Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 8912

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 8963

Why we need to use secondry database file? though, we can do same work using primary database file also.

Microsoft,

2 4809

What is difference between process and thread? Explain lazy writer funcationality.

Microsoft,

2 6113

What is live lock and deadlock? what is Lock escalation?

Microsoft,

2 6465

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

RBS,

1 3034

What is Primary key and foreign key? Give an example

TCS,

4 7029

How to connect PK and FK?

2 4187

What is the SQL?????????????????????????????

CMS,

5 4694

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

1109

what is an sql server?

1 2760

find 2nd highest salary of person using cursor concept?

HCL,

6 7263

how to find the second salary?

HCL, Prithvi,

10 7828

How to swap the data of two columns in a table. both the columns containing varchar values.

9 12486

What are the steps need to be take improve the speed of a SQLDATA Server?

IBM,

2 3453







Un-Answered Questions { SQL Server }

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1220


Explain microsoft sql server functions?

136


What is identity?

138


why would you call update statistics? : Sql server database administration

116


What are the essential components of sql server service broker?

143






Explain some stored procedure creating best practices or guidelines?

129


What is the difference between createstatement and preparedstatement?

97


Define model database?

127


Differentiate between a having clause and a where clause.

145


Explain what stored procedure sp_replcounters is used for? : sql server replication

159


What is explicit cursors?

128


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

127


How do I find information about the install locations for the various instances running on a computer?

145


What is clr ddl trigger?

124


Can we add an identity column to decimal datatype?

127