tags:

views:

20

answers:

1
Q: 

What is the best way to apply rowlevel writelock in T-SQL? Best Practices And Samples Please

What is the best way to apply rowlevel writelock in T-SQL? Best Practices And Samples Please

+1  A: 

The best way is to ignore lock level until you run into a problem and to trust SQL Server to do the right thing. In nearly 10 years working with SQL Server I had to go into locking level details ONCE.

TomTom  2010-03-25 12:49:23
@TomTom - Agreed. SQL Server is far smarter than any of us. It's know far better than us when to apply a row lock, page lock or table lock.
Randy Minder  2010-03-25 12:59:33
Sry but i need really apply rowlevel writelock in my scenario and i need best practices about it.
Kerem Kusmezer  2010-03-29 08:53:56
There is no best practice because it makes no sense to have one. Got it? What exactly is so special in your scenario that you have these requirements - I have not seen them ever since 7.0 created multiple insertion points.
TomTom  2010-03-29 11:35:19

related questions

*= in Sybase SQL
sql missing rows when grouped by DAY, MONTH, YEAR
Adapt Replace all strings in all tables to work with text
Can you call a webservice from TSQL code?
How to tell the data types after executing a stored procedure?
C# - SQLClient - Simplest INSERT
SQL Server: Get data for only the past year
Get last item in a table - SQL
Is there a way to make a TSQL variable constant?
Create a database from another database?
SQL Server PIVOT examples?
What are some references, lessons and or best practices for SQL optimization training.
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Trigger without a transaction?
How do I do an Upsert Into Table?
What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
How do I avoid using cursors in Sybase (T-SQL)?
Best .NET Solution for Frequently Changed Database
T-Sql date format for seconds since last epoch / formatting for sqlite input
HOWTO - Compare a date string to datetime in SQL Server?
Differences Between MySql and MS SQL
Best method for varchar date validation in Sybase (T-SQL)?
interrogating table lock schemes in T-SQL
Testing for inequality in T-SQL
T-Sql Remove Decimal Point From Money Data Type