Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

Lock Pages

1
July 5, 2011  2:00 PM

What does WITH (NOLOCK) actually mean



Posted by: Denny Cherry
Lock Pages

Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button.  While it may appear that way, there’s actually some stuff going on in the back that makes it look this way.  Understanding what is happening is critical to using WITH (NOLOCK) correctly. When you...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

June 7, 2011  9:00 PM

Taking locks without doing SELECT WITH UPDLOCK



Posted by: Denny Cherry
Lock Pages, sp_getapplock, sp_releaseapplock, sys.dm_tran_locks, Transactions

All to often developers need to force some locks on a table so that they can be sure that the records aren’t going to change between the time that they first look at the records and when the transaction is completed.  The most common method that I’ve seen to do this involves at the top...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

May 25, 2009  11:00 AM

VMware and SQL and Lock Pages in Memory



Posted by: Denny Cherry
Lock Pages, SQL, VMware

With the recent release of the ability for the Lock Pages in Memory setting to be used on SQL Server 2005 and 2008 Standard Edition I see more and more people shooting them selves in the foot with this setting when running under VMware.  I see this as becoming more of an issue now that this switch...

  Bookmark and Share     4 Comments     RSS Feed     Email a friend

April 26, 2009  5:29 AM

SQL Server Standard Edition getting Lock Pages in Memory



Posted by: Denny Cherry
Bob Ward, Bug, Lock Pages, Microsoft CSS, SQL Server 2005, SQL Server 2008

Microsoft SQL Server 2005 and 2008 Standard edition will be getting the Lock Pages in Memory feature that SQL Server Enterprise Edition has had starting in SQL Server 2005.  This was announced by Bob Ward via the

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

1