Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Fixed to varying length RE: Fixed to varying length

  • September 4, 2009 at 2:37 am

    #1049256

    Chirag (9/4/2009)

    That was a good one. Guess DBCC Cleantable also wouldn't help in this case.

    Thanks Chirag,

    According to BOL, DBCC Cleantable "Reclaims space from dropped variable-length columns in tables or indexed views."

    Since in this case a fixed length column is dropped, I'd agree with your guess. I didn't try it, though.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/