New answers tagged

6

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


15

                          Please note that the following info is not intended to be a comprehensive description of how data pages are laid out, such that one can calculate the number of bytes used per any set of rows, as that is very complicated. Data is not the only thing taking up space on ...



Top 50 recent answers are included