Large Empty Table

[guber]

I have a table in my database and this table receive temporary data from txt files (I do this using bcp.exe)

I load the data and if its ok, I transfer to the final table.

But they have a problem... this table (the table is empty now...) have 110 MB allocated... and they are very stranger... (slower...)

There isn´t any index or foreingn key...


Someone can help me ?


Thanks...

 

[dickiebird]

Why not drop the table after use, then re-create it (either immediately or better still, when next you want to load it up again)
HTH Dickie Bird (-)))

 

[tlbroadbent]

How can you tell that the space allocated is 110MB. How can access be slow if the table is truly empty? You shouldn't need to drop and recreate tables. Try this.

exec sp_spaceused table_name, @updateusage=true

@Updateusage=True instructs the procedure to update the space usage information which can be out of date. If you want to get the best answer for your question read faq183-874 and thread183-468158.


Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm