As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a little more accurate.
Missing Indexes Script v2
Tag: Index
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up that information. The required/requested information is […]
Table Sizes
In SQL Server there are two stored procedures that help one to determine the size of a table. One is documented and more widely popular, the other is not. These two stored procedures are sp_spaceused […]
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I have since seen a request to add to that script. The addition would add some […]
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior can be somewhat concerning since that view should have a unique entry for each index. […]
Index Info
I recently came across an interesting script to help show index info and usage. As I began to dissect the script, I noticed that the script was intended for SQL 2005 and beyond but was […]
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen several people asking about whether a foreign key should be indexed or not. I have […]
SQLFool IDX Defrag Scripts
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/
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. […]