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 |
|
texas_ducker
Starting Member
2 Posts |
 Posted - 2007-04-19 : 11:41:59
|
| I have several tables that have a large allocated space but approx. 85% unused space. So I've got allot of space allocated with very little of that space used. This is making my database very large. In the past I was able to cluster the offending indexes which helped greatly.But now the same tables have grown in allocated space but still very little real data in them. What is the best way to release the unused space allocated to these tables?If the solution is to drop and recreate the index can someone give me a detailed example as I've never done that before. SQL 2000 EnterpriseDatabase - ATRMainDBTable - ExamResponsesIndex - XIF116ExamResponsesThanks for the help |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-04-19 : 12:16:37
|
| If you want to steal some space allocated to the DB you can use DBCC SHRINKFILE command. Check books online for more info/how to use it.************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
texas_ducker
Starting Member
2 Posts |
Posted - 2007-04-19 : 13:23:15
|
| Dinakar - thanks, that worked great. I was making it harder than it needed to be as usual. |
|
|
|
|
|
|
Need help fixing table sizes