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 12010

What is difference between restoration and recovery in SQLServer?

Microsoft,

3 11707

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

Microsoft,

2 6769

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

Microsoft,

2 8060

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

Microsoft,

2 9168

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

RBS,

1 4302

What is Primary key and foreign key? Give an example

TCS,

4 9584

How to connect PK and FK?

2 5928

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

CMS,

5 8086

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

HP,

1911

what is an sql server?

1 4169

find 2nd highest salary of person using cursor concept?

HCL,

6 11700

how to find the second salary?

HCL, Prithvi,

10 12750

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

9 17188

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

IBM,

2 5125

Un-Answered Questions { SQL Server }

Does union all remove duplicates?

1022

How to retrieve error messages using odbc_errormsg()?

998

What are the restrictions while creating batches in sql server?

1012

Describe different Processing Modes offered by SSRS?

234

what is checksum in sql server.........???

1634

Give the query of getting last two records from the table in SQL SERVER?

905

Do you know how to send email from database?

936

Explain ranking functions?

1000

Define synonym?

1120

What are the advantages of using stored procedures?

898

Explain filtered indexes?

939

What type of locking occurs during the snapshot generation? : sql server replication

1266

How to create database with physical files specified in ms sql server?

960

Benefits of Stored Procedures?

933

How to select some specific rows from a table in ms sql server?

965

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