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 are the steps you can take to avoid “deadlocks”?

973

Explain user defined views?

957

What is catalog views?

1064

What is table-valued sub query?

961

What is the difference between a function and a stored procedure?

1065

What is the difference between update lock and exclusive lock?

971

Does the order of columns in update statements matter?

911

What is use of @@ spid in sql server?

1210

How to delete duplicate rows from table except one?

987

Can we insert data if clustered index is disabled?

939

Explain system rowset functions?

996

How can we solve concurrency problems?

1047

How can I check that whether automatic statistic update is enabled or not?

1040

If any stored procedure is encrypted, then can we see its definition in activity monitor?

984

What are wait types?

1104

Un-Answered Questions { SQL Server }

Define cursor locking

997

What is the full meaning of dml?

948

What is sql injection and why is it a problem? : sql server security

1128

Explain full-text query in sql server?

999

What are the advantages of using stored procedures in sql server?

1009

What is create command?

966

How to insert data into an existing table?

973

What is sql server management studio? : sql server management studio

1072

How many types of built in functions are there in sql server 2012?

922

Do you know hot add cpu in sql server 2008?

952

What is it’s similarity with sql server?

160

How do I open port 1433?

930

Explain log shipping?

1008

Why is sql server log file full?

1030

Do you know how to store and query spatial data?

1036

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