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 number sorts of privileges are accessible in sql?

1094

What are the difference between primary keys and foreign keys?

1022

Define normalisation?

1157

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

1108

What is sql sandbox in sql server?

1299

What is dbcc?

1181

How to delete exactly duplicate records from a table?

1116

What is the contrast amongst drop and truncate?

1082

What are data files?

1096

What is the difference between a clustered index and a non-clustered index?

1061

What are the difference between clustered and a non-clustered index?

1094

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

1251

What is the use of nvl work?

1049

How to optimize stored procedures in sql server?

1244

What is the difference between the 2 operating modes of database mirroring?

1166

Un-Answered Questions { SQL Server }

Explain transaction server distributed transaction?

1039

how would you store your query in an SSRS report or a Database server?

167

Why do we use trigger?

1031

How many types of database relationship in sql server?

1111

What is checkpoint in sql server?

1218

what data regions are and what are the different data regions?

146

when would you go for denormalization? : Sql server database administration

915

What is molap and its advantage? : sql server analysis services, ssas

1036

What is the contrast between sql and mysql?

1161

Where is trigger in sql server?

1107

What is constraints and its types?

1001

Explain the steps needed to create a scheduled job?

985

What is the difference between a view and a stored procedure?

1092

What is a cursor, index in sql?

1130

How to enable/disable indexes?

1130

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