Also, if you're on 2008, take a look at the built in reports on index usage, or you can write your own query based on the same base system view,...

1) SQL is very keen to suggest additional indexes; some are good, and you shouldn't ignore the suggestion, but make sure it's for a query that is run a lot,...

Partitioning is presented more as an admin tool than a performance enhancer, but it definitely improves range queries, because you scan only the range you need. Covering one partition as...

You should get better performance if you partition by month rather than by year, because the query will only cover the partitions (and thus data) it needs to, so 6...

Thanks mohammed,

and Ninja's_RGR'us

Could partitioning be used here (Never used it so I don't know). I know there's a way to drop...

Thanks, ALZDBA - I guess you're confirming what I figured, that there's no elegant way to do this, but as I'll have the database in single user mode in order...