Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bloated table: how to fix
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01200148
Message ID:
01200196
Views:
28
When I run that script or the orginal it is based on, I get no output. What was it going to tell me about my table, that I could fix?

>Try to run Bigtables script from Database Size Thread #869687 to get more detailed info.
>
>>I'm importing 13,000 records into a table and my SQL Server 2005 database bloats to 2.2 gigs. After doing a database shrink, the database itself drops a few percent in size and the log file drops to almost nothing.
>>
>>When I run EXEC sp_msforeachtable 'EXEC sp_spaceused ''?''' I get the following output
>
>>NAME     rows           reserved         data           indexsize unused
>>device	13520      	2207448 KB	2198992 KB	6808 KB	1648 KB
>
>>this shows me that it is my device table that is taking up almost all of the space. 2.2 gigs is way too big for the 13000 records.
>>
>>Is there a way to determine what is causing the table to bloat?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform