Steve Gemmen
Member since Dec 11, 2008
- Profile: /members/1426-steve-gemmen.htm
- URL: http://initapp.com
- Comments: 1
Recent Blog Comments By Steve Gemmen
-
SQL Server NOLOCK / ROWLOCK Directives To Improve Performance
Posted on Jan 20, 2007 at 9:50 PM
Just another tip. Save yourself some time in stored procedures where you're always implementing nolock by putting the following at the top of the proc. SET TRANSACTION ISOLATION READ UNCOMMITTED http://msdn2.microsoft.com/ en-us/library/aa259216(SQL.80).aspx Does the same thing and saves you t... read more »