We have a large table which contains a varbinbary(max) column. When I run the "Disk Usage by Top Tables" report, it shows that this table uses about 290 GB of data. However, when I sum the datalength for each of the columns in that table,
I get a total of 251 GB.
Why the difference in totals? I thought datalength() gave the size of the field in bytes, therefore I should be able to sum those bytes, convert them to gigabytes, then compare to the report...
Any help will be greatly appreciated. Thanks!
View Complete Post