tshad (9/12/2016)
True.That could be an issue if you have rows that large. I have a customer where some of out tables column definitions exceed the row size by hundreds of bytes. But the actual data would never come close that size as many of the columns are would never be used if other columns are used.
So in that case these 5 don't affect it at all.
But except for this customer the other customers I have dealt with don't have any rows close to that limit.
It's just the total space used, period. That's relatively a lot of bytes for any table that has a relatively large number of rows. Even 100M * all that space is a lot of extra "garbage" in the row. It makes it that much harder to tune the table for best performance.
That's another reason why such data is best stored out-of-table if possible.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.