• Adding columns to a table requires an exclusive table level lock, so it may be in a blocked state.

    Also, if the columns have a default value, then it's an increase in row size, so unless there is enough page padding, pages across the entire table get shuffled around.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho