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.