SQL Server Database Table Fragmentation
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
accepted
ASKER