>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?

Check Top Tips for Effective Database Maintenance.

I also recommend following blogs:

- http://www.sqlskills.com/BLOGS/KIMBERLY/
- http://www.sqlskills.com/blogs/paul
- http://blogs.msdn.com/sqlserverstorageengine/default.aspx
- http://blogs.msdn.com/conor_cunningham_msft/default.aspx