Post reply

Does SQL compression process takes additional temporary disk space?, 1.2 TB database to compress

  • August 29, 2018 at 8:16 am

    #2003809

    TomThomson - Tuesday, August 28, 2018 6:07 PM

    ScottPletcher - Tuesday, August 28, 2018 1:35 PM

    TomThomson - Tuesday, August 28, 2018 1:28 PM

    That makes sense - and it's what I thought I remembered happening las[t] time I used compression (more than a decade ago).

    Interesting.  SQL Server only added it a decade ago, so presumably it was a different rdbms?  Naturally I wouldn't imply that any of these methods necessarily apply to any dbms other than SQL Server.

    I guess 6 August 2008 isn't more that a decade ago if you are rounding to closest years. But a decade plus 22 days actually is more than a decade. I end to think of anything that happened before I retired as being more than a decade ago, although strictly speaking it sometimes isn't (as I didn't actually retire until some time in 2009). Besides, we'd been close enough to MS to be invited to take a place on their patch at a couple of trade shows, so maybe we got our hands on the release (or a non-release prerelease version?) a bit before the official date.  I had decided already that we wouldn't upgrade to SQL server 2008 before we moved the company headquarters (including all R&D) from London to Beirut because it was more important to get well into a newer OS version and the new interactive client-side IO structures that were taking shape in Windows (and probably would carry on changing a bit over the next year) but it was clear that we would have to get onto a more modern version of SQL Server soon so I spent a few hours playing with sql server 2008 as soon as it was available in case delaying upgrade was a mistake (it wasnt).

    Right, it wasn't, the upgrade from 2005 to 2008 was massive, as is the current upgrade from 2008 to 2016.  Until 2016, I couldn't really justify upgrading for the company I'm at now, but with 2016, it was genuinely worth it.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply