Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Modifying Lock Escalation in SQL Server

Created August 22, 2017 02:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samirbehara-zz/1930792a3f0de8e82638fdd7eea3dc76 to your computer and use it in GitHub Desktop.
Save samirbehara-zz/1930792a3f0de8e82638fdd7eea3dc76 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Modifying Lock Escalation in SQL Server
ALTER TABLE tablename
SET (LOCK_ESCALATION = DISABLE) -- or TABLE or AUTO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment