In my previous blog entry, I talked about index fragmentation and some of the tools that could be used to monitor and remove the fragmentation. The general rule to follow, according to Microsoft best ...

Does someone have a query off hand that provides the fragmentation level of all indexes within a database? I have one that targets a table -- but there are too many tables.

When I was young we used to go to see our local football, sorry, soccer team and cheer them on rain or shine on a Saturday afternoon in England. In those days the cheapest way to watch the game was ...