May 27, 2014 at 6:09 am
Hi all,
I've deleted a non clustered index that was taking up too much place but after running the exec sp_spaceused for the table, I've found that the index_size is still the same as it was before. I've tried running a DBCC CLEANTABLE and then rebuilding the index and I've also shrunk the database but nothing works.
Anybody have any suggestions?
May 27, 2014 at 8:41 am
TheComedian (5/27/2014)
Hi all,I've deleted a non clustered index that was taking up too much place but after running the exec sp_spaceused for the table, I've found that the index_size is still the same as it was before. I've tried running a DBCC CLEANTABLE and then rebuilding the index and I've also shrunk the database but nothing works.
Anybody have any suggestions?
Did you drop an index and then rebuilt the same?
May 27, 2014 at 10:29 am
Run the script here and see if it also reports that same size
http://jasonbrimhall.info/2014/03/28/table-space-updated-again/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply