Browse DevX
Sign up for e-mail newsletters from DevX

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



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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.



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