sql server programming: Is there a query to show actual record size for every row in a table?
--

Well, sort of. You could do select len(col1) + len(col2) etc.

Better ajust it to use this select len(isnull(col1,'')) +
len(isnull(col2,'')) so nulls wont bite you.

Or, you could set up a trigger that uses the technique above, and populates
a size col on insert or update to any row.

Then you can just query on the size col.



[quoted text, click to view]