Are you still rebuilding all of your SQL Server indexes every week, but you’re still having performance problems. Odds are, you’re not actually making things better: you’re making them worse! Learn about the 3 kinds of fragmentation, the 2 worst things you can do about it, and the 1 way to fix the problem permanently.
[youtube fD1CZVc6oUk]
Video producer: http://www.brentozar.com/