Post reply

Add columns to multiple tables

  • September 12, 2016 at 3:39 pm

    #1900419

    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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply