Ok. Thanks for the help today with helping me isolate why I have 2 almost identical databases, one is 11GB and one is 33GB.
I was able to find out that a few of the tables are way off in size proportions. In one database, the file is 354 MB, and the new DB, the same file is 8.9 GB!! The row count is identical and the number of columns is the same.
I tried dropping the table and an doing a full refresh, so my database is smaller, but there is still a lot of free space that won't go away when I shrink the DB.
1. Does anyone know the code to shrink each table one at a time?
2. Does anyone know how to remove the free space in my DB, the shrinkDB function is just not working.
I shrank the transaction log with the following statement and it only took a few seconds to get rid of 4GB:
BACKUP LOG ancosalesdm WITH TRUNCATE_ONLY
DBCC SHRINKFILE (ancosalesdm_log, 2)
However, I am now trying to shrink the 19 GB from my DB and am unsuccessful. I am running the following statement, but it keeps running forever, should I just wait it out? How long could it take to complete? Am I using the right SQL to do this?