New answers tagged

5

Maybe this is a grunge answer but this is what I would do. So DATALENGTH only account for 86% of the total. It is still very representative split. The overhead in the excellent answer from srutzky should have a pretty even split. I would use your second query (pages) for the total. And use the first (datalength) for allocating the split. Many ...


11

Data is not the only thing taking up space on an 8k data page: There is reserved space. You are only allowed to use 8060 of the 8192 bytes (that's 132 bytes that were never yours in the first place): Page header: This is exactly 96 bytes. Slot array: this is 2 bytes per row and indicates the offset of where each row starts on the page. The size of this ...



Top 50 recent answers are included