What are pessimistic lock and optimistic lock?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is service broker?
what is differencial backup?how to work?Anybody explai it?
Can truncate be rolled back?
What is the language structure to add a record to a table?
Why is sql server log file full?
What are cursors in ms sql server?
Do you know sql server 2008 introduces automatic auditing?
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
What are the types of subquery?
sql server architecture ?
What do you understand by recursive stored procedure?