• Chad Crawford (8/6/2009)


    Wow, that is interesting. I wonder what it is underneath that makes the difference. I'm cleaning up a lot of old data (horizontal and vertical), so this topic is quite opportune.

    However, this is a bit off-topic here, as the QotD was not about reclaiming free space after deleting all or any rows from a table, but after deleting one column without removing any row.

    Quite right. I'll take it elsewhere if I decide to pursue it.

    Well, you know about the vertical cleanup by know. 🙂

    For the details of horizontal celanup, I'd suggest posting a question to the newsgroup microsoft.public.sqlserver.server (if you have newsgroup access). Kalen Delaney regularly reads and replies there, and if anyone knows the fine details, she does!


    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/