THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » metadata » ALTER TABLE   (RSS)
  • Did you know? -- Altering the length of a fixed-length column

    You may be well aware that if you alter the length of a column to a larger value, that SQL Server doesn’t go through all the rows at the time you issue the ALTER. The ALTER is a metadata only change, and the actual movement of data doesn’t happen until a row is updated. However, SQL Server does not reuse the original bytes in the row when a ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on October 13, 2006
Privacy Statement