Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Oct 29, 1999

Use Enhanced SQL Server 6.5 Lock Manager's Row-Level Locking Granularity

Enhancements to the lock manager in SQL Server 6.5 provide row-level concurrency for INSERT operations. Properly implemented rowlock increases the speed of multi-user INSERT operations. Insert rowlock (IRL) is OFF by default. IRL can be enabled on individual tables or on an entire database by using the sp_tableoption stored procedure.

The example shows how the dbo can turn on the insert row lock option for all tables in the current database:

 
EXECUTE sp_tableoption '%.%', 'insert row lock', 'true' 
The new value for insert rowlock takes immediate effect on existing tables in the current database. For each table subsequently created, IRL must be explicitly set. This example shows how a user other than the system administrator or a dbo can turn off the insert row lock option for a table called MyTable:
 
EXECUTE sp_tableoption 'MyTable', 'insert row lock', 'false'
Jai Bardhan
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date