How do you optimize Sql queries ?1825
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 8099
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?4 25517
What's the difference between a primary key and a unique key?4 6873
What are user defined datatypes and when you should go for them?1 7225
What is bit datatype and what's the information that can be stored inside a bit column?1 4020
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement3 7531
Explain Active/Active and Active/Passive cluster configurations2 14611
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?7 45168
What is blocking and how would you troubleshoot it?2 4471
You want to use a perspective in an mdx query. How do you select the perspective?
How many types of triggers are there?
plss anybody specify tha constrian management system in dbms
What is an execution plan? When would you use it?
Differentiate between ms sql server reporting services vs crystal reports?
How global temporary tables are represented and its scope?
How to round a numeric value to a specific precision?
What is policy based management (pbm)? : sql server database administration
What are information schema views?
What is the current limitation of the size of SQL Azure DB?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is multilevel indexing?
How much does sql server 2016 cost?
What is dbcc updateusage?
What are the differences between decimal and float in ms sql server?