SQL Server Interview Questions
Questions Answers Views Company eMail

How do you optimize Sql queries ?



Rate yourself in .NET and SQL ?

SunGard, HCL, Cognizant,

1 5661

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 5505

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

Symphony, TCS, Credit Suisse, GCU,

4 21154

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

4 5127

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

1 6119

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

1 3060

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 104914

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


2 5587

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63644

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

3 5619

Explain Active/Active and Active/Passive cluster configurations

2 13213

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


8 23019

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


7 40131

What is blocking and how would you troubleshoot it?

2 3260

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


How do you Implement SSIS Packages in your Project?


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


tell me the disaster recovery plan


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


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


How to trouble shoot if unable to connect SQL Server


query processing


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


how to use DTS package in 2000,2005,2008 in sql server


How to restore performance issues and how to check?


How do use Having,Group by,Group function in SQL?


1 01 101 01010


what is difference between view and Dip.