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 5793

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 5643

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

Symphony, TCS, Credit Suisse, GCU,

4 21566

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

4 5220

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

1 6198

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

1 3124

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 105273

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


2 5736

What is a transaction and what are ACID properties?

IBM, TCS, Virtusa, Config Systems,

14 64278

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

3 5785

Explain Active/Active and Active/Passive cluster configurations

2 13328

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


8 23370

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


7 40597

What is blocking and how would you troubleshoot it?

2 3349

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How we create SQL Server 2005 Reporting Services ? Give me Sample


System variable and temporary variables


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?


Explain Capacity planning to create a database? and how to monitor it?


Why do you want to join software field as you have done your BE in Electronics?


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that


How to trouble shoot if unable to connect SQL Server


tell me the disaster recovery plan


Issues related in upgrading SQL Server 2000 to 2005 / 2008


What is best institute to Learn DotNET And SQL in chennai?


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


what is package and it uses and how can u call a package


whats the maximum size of view state??


New concepts of sql server 2005 use in your project.


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do