SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is SCOPE_IDENTITY() in sql

Cap Gemini,

4 12169

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 11834

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

Microsoft,

2 6884

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

Microsoft,

2 8169

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

Microsoft,

2 9310

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

RBS,

1 4397

What is Primary key and foreign key? Give an example

TCS,

4 9750

How to connect PK and FK?

2 6036

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

CMS,

5 8310

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

HP,

1945

what is an sql server?

1 4250

find 2nd highest salary of person using cursor concept?

HCL,

6 11890

how to find the second salary?

HCL, Prithvi,

10 13057

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

9 17515

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

IBM,

2 5226

Un-Answered Questions { SQL Server }

What is sql language?

1141

What is the difference between TRUNCATE and DROP?

1140

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1263

Are connections to sql server encrypted?

1003

What is the downside of using udf?

1109

What is not null constraint?

1121

How do you implement session management in SQL Server mode?

1100

Do you know what is bit data type and whats the information that can be stored inside a bit column?

957

What are different types of constraints?

922

What is the fastest way to permanently delete a 1 million row table named customers?

1255

How to disable a login name in ms sql server?

1134

Disadvantages of the indexes?

1125

Explain the stored procedure?

1053

How to reaname table name without using sp_Rename in sql server..?

996

What is implicit mode in sql server?

1105

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