Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can we suggest locking hints to SQL SERVER
Can we suggest locking hints to SQL SERVER ?
✍: Guest
We can give locking hints that helps you over ride default decision made by SQL Server. For instance, you can specify the ROWLOCK hint with your UPDATE statement to convince SQL Server to lock each row affected by that data modification. Whether it's prudent to do so is another story; what will happen if your UPDATE affects 95% of rows in the affected table? If the table contains 1000 rows, then SQL Server will have to acquire 950 individual locks, which is likely to cost a lot more in terms of memory than acquiring a single table lock. So think twice before you bombard your code with ROWLOCKS.
2007-10-25, 4909👍, 0💬
Popular Posts:
Assuming that the structure of a table shows two columns like this: --------+------------+-- ----+---...
Can we use the constructor, instead of init(), to initialize servlet? Yes , of course you can use th...
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
What are different properties provided by Objectoriented systems ? Following are characteristic’s of...
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...