title: Why did my SQL Server database fill up so fast, and how can I get back my space?
body: <p>Have a SQL Server environment in which we are using Microsoft SQL Server Management Studio to perform data analysis. The server capacity is 50GB and we loaded in about 8GB worth of '.csv' datasets using the Import Wizard. The 8GB worth of '.csv' files are no longer stored on the server environment.</p>
  
  <p>However, after a few days of querying and creating three new tables, the full 50GB is taken up.</p>
  
  <p>I tried to delete all interim tables, restart the server multiple times, turn off backup, and limit log autogrowth--all to no avail.</p>
  
  <p>How can I get back my storage space? Or at least figure out what is using it all up?</p>