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?

1088

What are the difference between primary keys and foreign keys?

1017

Define normalisation?

1155

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

1101

What is sql sandbox in sql server?

1297

What is dbcc?

1180

How to delete exactly duplicate records from a table?

1110

What is the contrast amongst drop and truncate?

1078

What are data files?

1094

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

1057

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

1090

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

1250

What is the use of nvl work?

1045

How to optimize stored procedures in sql server?

1242

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

1165

Un-Answered Questions { SQL Server }

Do you know what are different types of replication in sql server?

1155

Explain timestamp datatype?

1022

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1657

How to drop an existing schema in ms sql server?

1145

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1194

What are different types of statement?

1085

What is scrollable cursor?

1080

How to execute stored procedure in select statement sql server?

1114

Why can there be only one clustered index and not more than one?

1042

what is denormalization? : Sql server database administration

973

Why I have to use stored procedures?

1096

Can sql servers linked to other servers like oracle?

1009

What is sql server used for?

1100

What is 5nf in normalization form?

1045

How to include text values in sql statements?

1098

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