andrew_dale (10/29/2015)

---

you say

NOTE: There is a lot of available literature about pages, extents, and the affects they have on database design. Because of this, I won't go into the issue. It suffices to say we want to keep our table width below 1024 bytes when possible.

But the literature you reference https://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx says 8060 bytes per row before it has to start moving stuff off page.

Where did your 1024 byte width limit come from?