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?