Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
No Answer is Posted For this Question
Be the First to Post Answer
OPTIMIZATION OF SP,CURSOR,TRIGGERS
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
What are xml indexes?
What is application role in sql server database security? : sql server security
How to create function without parameter in sql server?
What is set nocount on?
Differentiate between a local and a global temporary table?
What is Command line parameters in PLSQL.?
What is normalization and denormalization in sql server?
What are the advantages of the mirroring?
Questions regarding Raiseerror?
How to find the version of sql server? : sql server database administration