Home Forums SQL Server 2016 SQL Server 2016 - Administration When adding new column to table, where is that data stored ? RE: When adding new column to table, where is that data stored ?

  • February 1, 2018 at 5:44 am

    #1978166

    There's no such thing as 'row chaining'. A row must fit onto a single page, the only exceptions being that data in varchar, nvarchar & varbinary columns can be partially or completely stored off-page (not good for performance though)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass