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

Tell me about builtinadministrator?

1042

Do you know what is xpath?

1152

What is public role in sql server?

1210

Explain full-text query in sql server?

1053

Do you know how to make remote connection in database?

1008

Tell me what are the advantages of using stored procedures?

1062

How to make remote connection in database?

1048

Explain what are the different index configurations a table can have?

1160

Tell me what is difference between view and materialized view?

980

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1055

Do you know concepts and capabilities of sql server?

1107

Explain how to use linked server?

1031

What do you mean by an execution plan? How would you view it?

959

Do you know what are acid properties of transaction?

1005

Explain what is lock escalation?

1109

Un-Answered Questions { SQL Server }

What is autocommit mode in sql server?

1265

Explain active/passive and active/active cluster configurations?

1107

What is difference in performance between insert top (n) into table and using top with insert?

1117

Where can you find the error log information? : sql server database administration

1071

What is Lock table in SQL?

1519

What sql server means?

1004

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1119

What is the difference between function and stored procedure in sql server?

1150

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1030

Why I can not enter 0.001 second in date and time literals in ms sql server?

1105

Describe different Processing Modes offered by SSRS?

256

Tell me can we use custom code in ssrs?

1050

How can you check the level of fragmentation on a table?

1087

Explain the ways to controlling cursor behavior?

967

What are the lambda triggers?

956

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