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

Why the trigger fires multiple times in single login?

1280

How to optimize stored procedure optimization?

960

What is use of except clause?

1139

What is an execution plan? When would you use it?

1026

What are “lock” hints?

1104

Explain ranking functions?

1094

How many clustered indexes there can be on table ?

1071

What is user-defined multi-statement table-valued function?

1120

Why de-normalization required?

1053

What is co-related sub query?

1072

Explain trigger and trigger types?

1035

Which are the new data types introduced in sql server 2008?

927

How we can compare two database data?

996

Explain aggregate functions?

1138

What is self contained multi valued query?

1074

Un-Answered Questions { SQL Server }

Can you explain what are various ways to enhance the ssrs report?

1066

What are the differences between having and where clause.

1016

How to find related tables in sql server?

1001

what are the critical issues you have resloved in your company

2016

What are the encryption mechanisms in sql server?

1080

What is dirty page?

1035

What is BCNF? How is it better than 2NF & 3NF?

1065

What is the name of the Database which IBM mainframe uses?

1030

Explain error and transaction handling in sql server?

1062

What is linked report?

137

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1066

What is merge statement?

1132

What the different components of Replication and what is their use?

1125

what is unique and xaml nonclustered index

1098

what type of index will get created after executing the above statement? : Sql server database administration

1028

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