Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srivatsahg
Yak Posting Veteran
71 Posts |
 Posted - 2009-07-30 : 10:43:23
|
| Hello all,I have a basic question. I have a big table >400000 records.The table i use also has some columns indexed(Non Clustered Index).As far i as i know these indexes occupy some space in the database.I can see the amount of space consumed by the indexes and data through SQL Server Reporting tool.Say 20GB, is the Total Space UsageNow if i drop some indexes for that table, i should be able to see the space freed up after clearing the indexes.i.e The total space usage i should see is 20GB - (space occupied by the dropped indexes)However i still see the same 20GB as the total space usage.Any pointers in this direction as to how to clear and reclaim the space so that i can say that indeed the indexes has been dropped and the space reclaimed...RegardsSrivatsa |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-07-30 : 10:47:25
|
| Have a look in Books on line at dbcc shrinkdatabase, that should do the trick for you |
 |
|
|
|
|
|
Reclaim space after dropping an index