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”?

1024

Explain user defined views?

1008

What is catalog views?

1121

What is table-valued sub query?

1026

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

1124

What is the difference between update lock and exclusive lock?

1028

Does the order of columns in update statements matter?

954

What is use of @@ spid in sql server?

1272

How to delete duplicate rows from table except one?

1042

Can we insert data if clustered index is disabled?

986

Explain system rowset functions?

1045

How can we solve concurrency problems?

1098

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

1093

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

1041

What are wait types?

1199

Un-Answered Questions { SQL Server }

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1110

What command would you use to create an index?

1107

Explain the phases a transaction has to undergo?

1112

What is indexed view?

1025

How to find the list of fixed hard drive and free space on server?

1281

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2077

What is the maximum number of index per table?

1117

How to throw custom exception in Stored Procedure?

1095

What is faster join or union?

1318

What is importing utility?

1038

What is a synonym for manipulation?

1046

How to generate create procedure script on an existing stored procedure?

1062

What does the update command do?

1173

What is the difference between a local and a global temporary table?

1174

Explain the steps needed to create a scheduled job?

979

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