Tac11 (3/1/2015)
Hi Jeff,After i divided size (KB) with Rows it came out 30 KB (around) size for each row. So each page contains 8 KB. So a row on my table contains almost 4 pages?
Yep... Blobs (MAX datatypes, XML, etc) live in other "tables" and are handled differently than "in-row" data but that's what it boils down to and that probably includes the weight of indexes, which are also important in capacity planning.
--Jeff Moden
Change is inevitable... Change for the better is not.