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?

1204

How to optimize stored procedure optimization?

890

What is use of except clause?

1092

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

972

What are “lock” hints?

1053

Explain ranking functions?

1041

How many clustered indexes there can be on table ?

1024

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

1056

Why de-normalization required?

995

What is co-related sub query?

1021

Explain trigger and trigger types?

963

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

879

How we can compare two database data?

940

Explain aggregate functions?

1078

What is self contained multi valued query?

1010

Un-Answered Questions { SQL Server }

List few advantages of stored procedure.

981

Write a query for primary key constraint with identity key word?

1027

Which is the latest version of sql server and when it is released?

1106

What is the difference between local and global temporary tables?

1138

what are acid properties? : Sql server database administration

995

List the advantages of using stored procedures?

1046

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2071

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2067

Where cross join is used?

955

What are the components of dbms?

952

Explain boyce and codd normal form(bcnf)?

949

What is dynamic cursor in SQL SERVER?

1077

What is replication and database mirroring?

1043

Can a database be shrunk to 0 bytes, if not, why?

1098

What is an indexed view?

952

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