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 is a join in sql?

1093

Why use update_statistics command in sql server?

1058

List out the difference between union and union all in sql server?

991

What are locks in sql?

985

In what sequence sql statement is processed?

1016

Explain how many types of relationship?

1030

What is de-normalization in sql database administration? Give examples?

985

List the different types of collation sensitivities in sql server?

1044

Why use cursor in sql server?

1081

Write the syntax for stuff function in an sql server?

1030

What does man by sql wildcard characters in sql server?

1062

Explain about unique identifier data type in sql server?

920

List all types of constraints in sql server?

1045

What are views used for?

1015

What are constraints?

1013

Un-Answered Questions { SQL Server }

What are trace flags and mention a few common trace flags used with sql server?

1088

What is the minimum recommended amount of ram for sql server 2012 enterprise?

935

What are the character string functions supported by sql server 2005?

1014

How to send email from database?

1015

How to drop existing views from a database in ms sql server?

1103

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1206

How to get a list of columns using the "sys.columns" view in ms sql server?

954

What happens if we shrink log file in sql server?

983

Explain the etl (extraction, transformation, and loading)?

996

How to find Duplicate Records In table?

1018

What are the 7 disadvantages to a manual system?

984

How do you set a trace flag in sql server?

1039

What are the lambda triggers?

905

How can you start sql server in different modes?

973

How many joins in sql server?

958

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