Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 6525

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 6440

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

Credit Suisse, GCU, Symphony, TCS,

4 23347

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

4 5778

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

1 6579

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

1 3438

Define candidate key, alternate key, composite key.

Infosys, Software India,

13 107193

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


2 6421

What is a transaction and what are ACID properties?

Config Systems, IBM, TCS, Virtusa,

14 67380

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

3 6470

Explain Active/Active and Active/Passive cluster configurations

2 13803

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


8 24990

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


7 42619

What is blocking and how would you troubleshoot it?

2 3780

Un-Answered Questions { SQL Server }

What is merge replication?


According to you what goes into making the best database administrator? : sql server database administration


How many replicas are maintained for each SQL Azure database?


What is difference between joins and subqueries?


Can I delete event logs?


what happens on checkpoint? : Sql server database administration


What is a linked server in sql server?


Explain the various types of concurrency problem?


Explain optimistic and pessimistic concurrency?


How to modify the underlying query of an existing view?


Do you know what is difference between index seek vs. Index scan?


What is the difference between mysql and mysqli?


What is the purpose of sql profiler in sql server? : sql server database administration


What is check constraint in sql server?


What is key attribute?