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 |
|
lcpx
Yak Posting Veteran
54 Posts |
 Posted - 2006-07-21 : 07:40:22
|
| We have a table with about 200,000 records, 50 columns. in SQL Enterprise Manager diagram, it shows the table take about 40 megabyes. Well it worked perfectly in the last couple years, but recently it just get really slow.So I created a new table with exactly the same table structure. Then I use "Insert into target_table select * from Original_Table" SQL to import all the data to this new table, and then we started to use the new table. It worked OK at the first week, but it's getting slow again. When I checked the propertie in the Enterprise manager, it shows the table take 400mega bytes. 10 times larger than original one with same table structure and same records. What is going wrong?Thanks very much for your time and help! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-21 : 08:33:26
|
| Have a look at the page density.Try sp_spaceusedTry rebuilding the clustered index or defragmanting - could be that you have done deletes on the table and not recovered the free space.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Tables are same but in different size