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 |
|
Credo
Starting Member
5 Posts |
 Posted - 2009-07-19 : 19:43:38
|
| Okay - here's where I'm at now. I managed to temporarily free up an extra 500mb of space, by removing some old files from the server and whatnot. This allowed me to create a backup of the existing database as is. I then deleted some historical data:DELETE FROM LOAD_PROFILE_DETAILS WHERE CREATED_DATE < '2006-06-01 00:00'That cleared about 800000 lines of data from that table. I then shrunk the database, and managed to get about 9gb cleared up..HOWEVER - Here's where I have my problem now.When I ran SP_SPACEUSED 'LOAD_PROFILE_DETAILS'The "Reserved" column read almost 95Gb, and the Data column only read about 32 - even after the Database shrink. I read that the next option would be a DBCC DBREINDEX. My only question is I don't know what value to put as the fillfactor??? The help file says if you leave it at 0, it will default to the original setting.Will this help decrease my reserved value? And how long does a REINDEX take?I thank everyone in advance, I'm not a DBA by any means, but my employer has somehow bestowed that privilege on me. I'm still waiting for them to send me on some sort of formal training....Again, any help would be greatly appreciated. |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-07-20 : 11:28:44
|
| There is a command for updating stats I used this when my msdb was reporting an incorrect size after a massive shrink. DBCC UPDATEstats maybe?There are several threads here about shrinking database size and managing the tlog. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-07-20 : 12:23:14
|
You should run this command to make sure the usage statistics in that database are up to date.exec sp_spaceused @updateusage = 'true' After that, you can run the script on this link to look at the size of the individual tables:Script to analyze table space usagehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762CODO ERGO SUM |
|
|
|
|
|
|
My DB size woes continue..