Sql Server stores data on 8-kilobyte data pages. A page is one of the levels of granularity when locking resources. Other levels include row, extent, table.
The database acquires the appropriate level of locks to minimize the cost, so instead of locking individual rows it could decide to lock the complete page, to minimize the number of locks needed, or it could even decide to lock a complete table, depending on the operation being performed.
Here is a list of the different granularity levels.
<a href="http://msdn.microsoft.com/en-us/library/ms189849.aspx">Lock Granularity and Hierarchies</a>
Depending on the size of the rows in the table it could be one row, or as many as 65536 rows (if each row was a single bit column and there were no other columns).
Last Wiki Answer Submitted: April 21, 2010 4:39 pm by carlosdl63,535 pts.