How do you minimize the amount of fragmentation on your database tables that are heavily used?
I have an online SQL Server 2008 (SP2)supported application, the database has two tables that shows heavy reads/write and delete. Due to the read/write and deletes, the columns becomes easily fragemented. However, I tend to rebuild the indexes very often, but the more I rebuild the more fragmented the indexes. So, can somebody tell exactly what I needed to do if possible to minimize the level of fragmentation on these tables?