How do SQL 2000 perform row level locking ? 
Author Message
 How do SQL 2000 perform row level locking ?
Hi All,
Can anybody tell me the internet site or the information which tells
how do SQL Server 2000 stores data in a page to perform row level locking?

Does sql 2000 store one row per page(8KB) to enable row level locking even
if row size is much smaller than 8KB?

Thanks
RB



Sat, 15 Nov 2003 11:11:54 GMT
 How do SQL 2000 perform row level locking ?

SQL Server does not store one row per page to get row level locking. SQL Server has a
structure for table locks, one structure for page locks and (as of 7.0) on structure
for row locks. More information in SLQ Server Books Online, and much more in Inside
SQL Server, MS Press.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

Quote:

> Hi All,
> Can anybody tell me the internet site or the information which tells
> how do SQL Server 2000 stores data in a page to perform row level locking?

> Does sql 2000 store one row per page(8KB) to enable row level locking even
> if row size is much smaller than 8KB?

> Thanks
> RB



Sat, 15 Nov 2003 14:13:01 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. table-level lock or row-level lock

2. Row level locking in MSDE 2000

3. row-level locking with dao and access 2000

4. row level vs page level locking is it more than marketing

5. row-level or page-level locking?

6. row level locking and dead-lock prevention

7. Page lock to simulate row level lock

8. row level locking and dead-lock prevention

9. Paradox 5.0: Row level locking or page locking?

10. Behavior of locks at different perform levels

11. Behavior of locks at different perform levels

12. table level locks, row level locks, column level locks?


 
Powered by phpBB® Forum Software