What is collation?
Explain mixed authentication mode of sql server?
What is a Trace frag?Where can we use this?
how to copy only distinct data into another table which is not already exist in database?
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
Should you normalize audio?
What are the new security features added in sql server 2012? : sql server security
What is lock escalation?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to define the name and server for a new dsn?
What is sql server used for?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How to view the error log for any specific instance? : sql server database administration