anthony.green (11/30/2012)
sanket kokane (11/30/2012)
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 ?
As long as the second row is 3900 bytes or less.
The example was that if every row takes 4100 bytes, so that would mean that only 1 row can be stored on a page, the remaining 3900 bytes could only ever be used by the row occuping the page.
what if second row size > 3900 int this case .
Row overflow can take place or not ?
or it will go directly to the another new page?
-----------------------------------------------------------------------------
संकेत कोकणे