I will tell share with you two issues from our recent migration from 2000 to 2008 enterprise.

1) Several of our 2000 tables were OVER-indexed or had the wrong indecis on...