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?

1211

How to optimize stored procedure optimization?

892

What is use of except clause?

1092

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

978

What are “lock” hints?

1057

Explain ranking functions?

1046

How many clustered indexes there can be on table ?

1038

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

1061

Why de-normalization required?

1002

What is co-related sub query?

1021

Explain trigger and trigger types?

983

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

879

How we can compare two database data?

946

Explain aggregate functions?

1081

What is self contained multi valued query?

1016

Un-Answered Questions { SQL Server }

Describe in brief system database.

1011

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1217

What are subquery and its properties?

1049

Explain how to maintain a fill factor in existing indexes?

995

What is store procedure? How do they work?

1022

Which are new data types introduced in sql server 2008?

1049

Is INSTEAD OF trigger directly applicable to Table ?

1017

What happens if the update subquery returns no rows in ms sql server?

1124

What is difference between getdate and sysdatetime in sql server 2008?

1047

Explain what are commit and rollback in sql?

931

When I delete any data from a table, does the sql server reduce the size of that table?

1018

Can you please explain the difference between function and stored procedure?

1007

What is report snapshot in ssrs?

268

Does sql server use java?

1073

How many types of database relationship in sql server?

1054

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