OPTIMIZATION OF SP,CURSOR,TRIGGERS
What are the different types of cursor?
How to find the login name linked to a given user name?
How can you see what type of locks used?
What are the steps you will take to improve the performance of a poor performing query?
what is a transaction and what are acid properties? : Sql server database administration
What is change data capture (cdc) feature?
what is memory-optimized nonclustered indexes
Write query to return all rows sql?
What is inner join in sql server joins?
What do you understand by integration services in sql server?
how you can move data or databases between servers and databases in sql server? : Sql server administration
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005