>If I add 1000 records in a table and remove all of them. Does SQL Server keep that empty space or will it recycle it? By that, I mean, once in a while, is there any reason to do a database compress?
Another even more interesting blog
http://redmondmag.com/features/article.asp?EditorialsID=2560
If it's not broken, fix it until it is.
My Blog