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 isnull() operator?

1034

What is coalesce in sql server?

1049

What is the use of set nocount on/off statement?

1095

What are the differences between stored procedure and the dynamic sql?

1087

How to delete duplicate rows in sql server?

1102

What will be the maximum number of index per table?

999

What is the use of =,==,=== operators?

1006

How data can be copied from one table to another table?

944

How can we get count of the number of records in a table?

952

What is the purpose of floor function?

1032

What is tablesample?

1105

What are the differences between local and global temporary tables?

1078

What is the command used to recompile the stored procedure at run time?

1077

What are the methods used to protect against sql injection attack?

1061

Can sql servers linked to other servers?

1033

Un-Answered Questions { SQL Server }

Explain having clause and where clause?

1052

What is the index requirement in SQL Azure?

Explain a differential backup?

1004

What does it mean to invest in the index?

963

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

936

What is sql service broker?

975

What are various limitations of the views?

1049

What are the different authentication modes in sql server? How can it be changed?

1084

What is the default schema of your login session in ms sql server?

1047

what are isolation levels? : Sql server database administration

985

Explain transaction server consistency?

966

What is SQL Azure?

105

What is the difference between coalesce() & isnull()?

1131

what are the new features in SSRS?

134

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1028

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