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 5699

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 5543

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

Symphony, TCS, Credit Suisse, GCU,

4 21276

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

4 5153

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

1 6143

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

1 3076

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 105016

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


2 5634

What is a transaction and what are ACID properties?

Virtusa, TCS, IBM, Config Systems,

14 63814

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

3 5672

Explain Active/Active and Active/Passive cluster configurations

2 13244

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


8 23125

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


7 40272

What is blocking and how would you troubleshoot it?

2 3286

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

how can you attach more than 20 ldf files in sql server


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


System variable and temporary variables


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?


what is the sql equivaent of the dataset relation object ?


How much memory that we are using in Logshipping Concept?


What is the difference between NOROW and LOCKROW?


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


where the connection string store in the database


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?


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


1 01 101 01010


Comment,Datatypes are unlimited