How do you optimize Sql queries ?1475
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?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
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement3 6470
Explain Active/Active and Active/Passive cluster configurations2 13803
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
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?