We have a need to fit a database in 4GB in order to use SQL Server Express Edition. I started from a 7GB database, and found a lot of unneeded records, and deleted them. After shrinking, the database size is 4.6GB, and 748 MB is free (according to database properties).
However, when I execute
exec sp_spaceused, I have interesting results:
DatabaseName Database_size unallocation space xxxxxx 4726.50 MB 765.42 MB
Reserved Data index_size unused 3899472 KB 1608776 KB 1448400 KB 842296 KB
Any ideas, how can I release at least some of this unused space?
Also I know table, which occupied it.
Update: is it worth to trying to rebuild table indexes?
ALTER INDEX ALL ON Production.Product REBUILD