Reduce size of SQL Server database [closed]

Posted on

Question :

How can I reduce my SQL Server 2008 database size?

My application is slow as as a result of increasing db volume.

Answer :

You have three options, none of which will involve me telling you to shrink your database:

  1. Archive old data by deleting it
  2. Archive old data by moving it to another database and use views to allow people historical access
  3. If you’re on Enterprise Edition, check out data compression

There are also magical options which require no data movement or deletion:

  1. Add as much RAM as your server and licensing allows
  2. Tune indexes using a script like sp_BlitzIndex (full disclosure, I’m one of the authors of that script)

Leave a Reply

Your email address will not be published. Required fields are marked *