I have a database in which I dropped several large tables. I would like to reclaim the unused space. The size of the database was 51gig. Then I backed up the database. The size of the database backup went from 41gig to 15gig. Then I restored the database from the new backup of 15gig. The database size did not change from it's original size. It was still 51gig.
When I run sp_spaceused, I get the following results:
database_name database_size unallocated space
Aspx2_DW 51703.25 MB 37062.80 MB
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…