SQL Server Tips, tricks, blogs, articles, content

Who is online?  129 guests and 0 members
home  »  blogs  »  Quick Tip: September 2011

SQLServerGeeks.com Blogs

Blogs RSS Feed

Quick Tip :September 2011 postings

Quick Tip

Want to enable Partition-Level Locking in SQL Server 2008?

9/30/2011 4:14:43 PM by Quick Tip  -  Comments: 1  -  Views: [4053]

In SQL Server 2008, lock escalation to Table object is default. You can make partition-level lock escalation as default as follows: ALTER TABLE [Table_Name] SET (LOCK_ESCALATION = AUTO); For more detailed explanation, see this: http://www.sqlservergeeks.com/articles/sql-server-bi/73/sql-server-2008-%E2%80%93-partition-level-locking Regards Quick Tip from SQLServerGeeks.com

Read More

Page 1 of 1 (1 items)

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Email Subscriptions

   Get the Most Recent Blogs in your inbox