O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Lock Granularity Hints

You can use to lock granularity hints to override the lock granularity selected by the Query Optimizer:

Image ROWLOCK—You can use this option to force the Lock Manager to place a row-level lock on a resource instead of a page-level or a table-level lock. You can use this option in conjunction with the XLOCK lock type hint to force exclusive row locks.

Image PAGLOCK—You can use this option to force a page-level lock on a resource instead of a row-level or table-level lock. You can use this option in conjunction with the XLOCK lock type ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required