Community Member Profile
Repriser
Member since Jan 4, 2010
- Profile: /members/5089-Repriser.htm
- Comments: 2
- Points: 36
Recent Blog Comments By Repriser
-
SQL Server NOLOCK / ROWLOCK Directives To Improve Performance
Posted on Jan 4, 2010 at 4:05 PM
I have also seen MS SQL server locks for a long time even insert one row, this includes happening to msdb.dbo.syssessions table.... read more »
-
SQL Server NOLOCK / ROWLOCK Directives To Improve Performance
Posted on Jan 4, 2010 at 2:55 PM
NOLOCK gets you isolation level as READ UNCOMMITTED. Use it only when it is suitable.... read more »
