I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for Beta testers. Anybody that is interested could find more info at: http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/
Tag: clustered index
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In this post, I will discuss some of what I did to further tune the query. […]
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some aggregations and performs a range scan based on a date value passed to the query. […]
Primary Key Discovery II
Primary Key discovery and beyond.