March 12, 2005
MySQL Cheat Sheet
This is useful.
Posted by 0xFF3300 at 09:37 AM | Comments (0) | TrackBack
January 06, 2004
SQL Server Locks - NOLOCK and ROWLOCK
I found a decent article that seems to explain proper use of NOLOCK and ROWLOCK. When working with large amounts of data, not using ROWLOCK can cause serious performance problems, for example incoming queries can basically be blocked by a SELECT statement to that table or even a JOIN on that same table. Note that SQL Server Optimizer hint NOLOCK is indentical to setting the transaction isolation level to READ UNCOMMITTED.
SQL Server Locks - NOLOCK and ROWLOCK
Posted by 0xFF3300 at 06:20 PM | Comments (0)