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 |
|
mark_b
Starting Member
24 Posts |
 Posted - 2008-04-09 : 10:22:03
|
Hi all,I am still relatively new to the SQL world, and have just started looking at purging data from my databases which is older than 8 years old. I am using a routine from another forum on here to get a before Table size pre purge, and then running it again to get the new size after.The thing i have found is that even though i have deleted over 1.5 million rows, there is actually no difference in the table size. I have been looking at the UPDATE STATISTICS on the msdn web pages to see if i need to run this to update the information i am using for size comparisons, but it doesnt really tell me if this is one of the things that it updates, and was wondering if i was being dumb and missing something completely obvious here. The other thing i can think of is that even though the data has been deleted, the space has been retained in the indexes on the tables, and until i do a re-index i will not realise the space savings?Many thanks in advance, and feel free to point and snigger if i have just missed something staring me in the face  Mark |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 10:35:59
|
| Rebuilding indexes will release space saving and your log files will grow if you delete 1.5 million records.Check this out:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1644521&SiteID=1 |
 |
|
|
|
|
|
Question relating to Table size