Find Unindexed Foreign Keys (2005)
This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.
2011-12-20 (first published: 2007-08-10)
3,723 reads
This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.
2011-12-20 (first published: 2007-08-10)
3,723 reads
Calculates server uptime in days, hours, and minutes. Also calculates the UTC date (smalldatetime) when the server was started.
2011-11-17 (first published: 2007-08-31)
2,411 reads
To report indexes proposed by the database engine that have highest probable user impact. Note that no consideration is given to 'reasonableness' of indexes-- bytes, overall size, total number of indexes on a table, etc. Intended to provide targeted starting point for holistic evaluation of indexes.
2007-08-17
963 reads
This is an enhanced version of my previous script: Prioritize Missing Index Recommendations (2005).To aid in evaluation of whether the recommended index is reasonable, I have added :1. counts for key columns and the total columns of the recommended index 2. the length/bytes for both key and all columns Note this is 'per row', not […]
2007-08-17
1,828 reads
By HamishWatson
This blog post relates to where you might be doing scale operations of your...
By HamishWatson
This blog post is about a situation where writing an IF THEN ELSE statement...
By Steve Jones
Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...
Comments posted to this topic are about the item Data Privacy Grows in California
Hi I need to grant a user access to a DB on the server...
I have this table that unfortunately has spaces in the field, which I am...