Browse by Tags

• ALTER TABLE
• rowsize

• 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 Read More... Posted Friday, October 13, 2006 10:33 AM by Kalen Delaney | 8 Comments Filed under: rowsize, metadata, storage, ALTER TABLE