Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    Unanswered: question about adding columns

    Recently, I was asked to add some new, nullable columns to a fairly large pre-existing table. It worked like a champ, but I was surprised that it finished almost immediately, and didn't appear to use much (if any) log space.

    How does this work? My google-foo fails me. I would think the entire table would have to be re-written & copied to a new data structure.


  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    Only when you update the column to contain data might a page split occur if there are no room to fit the new data on the current page

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts