How much fragmentation is bad? How low of scan density is too low? How low does scan density is bad? i have a table with the following index density and fragmentation levels:
i\'m going to running some queries against an SQL Server database, followed by a delete. Ideally all this happens inside a transaction (i.e. atomic).
I am working on a data driven web application that uses a SQL 2005 (standard edition) database. One of the tables is rather large (8 million+ rows large with about 30 columns). The size of the table