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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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

For More Un-Answered { SQL Server } Questions Click Here