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).

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.

ramyours2003 (11/29/2012)

---

HOW MANY datapages in sql ?

Sean Lange (11/29/2012)

---

Everybody knows this is 42

sanket kokane (11/30/2012)

---

you sounds like only one row per page ,right ?

http://msdn.microsoft.com/en-us/library/ms190969%28v=sql.105%29.aspx



I think remaining space can be used by other rows .

Please can you share any link related it ?

anthony.green (11/30/2012)

---

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.

anthony.green (11/30/2012)

---

No as it has to be the row which overflows, not the page. The row is not overflowing as its 4100 bytes, for row overflow to occur the whole row must be > 8060 bytes.