Tag Info

New answers tagged

8

You've added a new column, but SQL Server - if the default value is a runtime constant - will not update the existing pages that hold the table's data, it will be only a metadata change and that's the reason you see no increase in the space used. For all intents and purposes (as Aaron mentioned in a comment), the values are there - and a SELECT will reveal ...



Top 50 recent answers are included