Home Forums SQL Server 2008 T-SQL (SS2K8) Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ? RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

  • Impossible to say.  It depends primarily on (1) how much free space is available in each page already, (2) as noted already, how many affected indexes there are on each table.

    If the first table had no free space per page, and the second table had a lot, the first would likely be more overhead.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.