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 12162

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 11808

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

Microsoft,

2 6873

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

Microsoft,

2 8162

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

Microsoft,

2 9297

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

RBS,

1 4390

What is Primary key and foreign key? Give an example

TCS,

4 9737

How to connect PK and FK?

2 6017

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

CMS,

5 8285

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

HP,

1944

what is an sql server?

1 4247

find 2nd highest salary of person using cursor concept?

HCL,

6 11876

how to find the second salary?

HCL, Prithvi,

10 13014

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

9 17484

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

IBM,

2 5222

Un-Answered Questions { SQL Server }

How to convert numeric values to integers in ms sql server?

1087

Define compound operators?

911

What are the dis_advantages of stored procedures, triggers, indexes?

2219

What is snapshot report?

165

What new changes are being made in SQL Server?

1178

How to create user messages with print statements in ms sql server?

983

Explain the concepts and capabilities of sql server?

968

How to modify an existing stored procedure in ms sql server?

1078

How to delete an existing database user?

1013

Write a program to fetch first 10 records from a file?

1001

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1046

What is side by side migration in sql server?

1095

what information is maintained within the msdb database? : Sql server administration

968

What is triggers and stored procedures?

937

What is table value parameters (tvp)?

1098

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