ScottPletcher (11/29/2012)
Depends on how many bytes in table, and how long a row is.A SQL page is 8K, with 8060 total bytes available for data. Each row resides on a single page (excluding special column types).
you sounds like only one row per page ,right ?
http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx
So if every row takes, say, 4100 bytes, each would take a whole page, with the rest of that page unuseable except to expand the existing row.
I think remaining space can be used by other rows .
Please can you share any link related it ?
-----------------------------------------------------------------------------
संकेत कोकणे