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?

1091

What is coalesce in sql server?

1104

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

1140

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

1139

How to delete duplicate rows in sql server?

1154

What will be the maximum number of index per table?

1055

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

1058

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

1004

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

996

What is the purpose of floor function?

1093

What is tablesample?

1176

What are the differences between local and global temporary tables?

1131

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

1120

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

1119

Can sql servers linked to other servers?

1097

Un-Answered Questions { SQL Server }

What is an execution plan? How would you view the execution plan?

1129

What new data source types were added in ssrs 2014?

169

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1073

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

1093

How can we check the sql server version?

1128

what are acid properties? : Sql server database administration

1058

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

947

What is collation sensitivity? Explain different types.

1056

How to convert binary strings into integers in ms sql server?

1081

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1099

What are the new features of sql server 2008 r2 reporting service?

212

What is the federation in sql azure?

How check triggers in sql server?

1050

How can you control the amount of free space in your index pages?

1101

Explain difference between control flow and data flow?

1017

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