Morning,
If you have a query that you know update every row in a table, is there a significant performance benifit in aquireing an exclusive table lock within the query (as opposed to SQL Server escalating various lower level locks)?
Hope this makes sense.
Cheers,
TheGeezza
If you have a query that you know update every row in a table, is there a significant performance benifit in aquireing an exclusive table lock within the query (as opposed to SQL Server escalating various lower level locks)?
Hope this makes sense.
Cheers,
TheGeezza