SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?



Rate yourself in .NET and SQL ?

Cognizant, HCL, SunGard,

1 7812

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 8099

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

Credit Suisse, GCU, Symphony, TCS,

4 25517

What's the difference between a primary key and a unique key?

4 6873

What are user defined datatypes and when you should go for them?

1 7225

What is bit datatype and what's the information that can be stored inside a bit column?

1 4020

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 110934

What are defaults? Is there a column to which a default can't be bound?


2 7549

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 72416

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 7531

Explain Active/Active and Active/Passive cluster configurations

2 14611

What is RAID and what are different types of RAID configurations?


8 27117

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?


7 45168

What is blocking and how would you troubleshoot it?

2 4471

Un-Answered Questions { SQL Server }

You want to use a perspective in an mdx query. How do you select the perspective?


How many types of triggers are there?


plss anybody specify tha constrian management system in dbms


What is an execution plan? When would you use it?


Differentiate between ms sql server reporting services vs crystal reports?


How global temporary tables are represented and its scope?


How to round a numeric value to a specific precision?


What is policy based management (pbm)? : sql server database administration


What are information schema views?


What is the current limitation of the size of SQL Azure DB?


Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many


What is multilevel indexing?


How much does sql server 2016 cost?


What is dbcc updateusage?


What are the differences between decimal and float in ms sql server?