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,735 reads
Michael Smith
Server Up-Time Information
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,413 reads
Prioritize Missing Index Recommendations (2005)
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
966 reads
Prioritize Missing Index Recommendations 2 (2005)
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,838 reads
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
Running Trace - Error: Login timeout expired
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
query perf issue
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Looking for some guidance on avoiding Scalar UDFs for DB lookups
Hello. I am not a SQL Developer - just an IT generalist (if that)...
Ask SSC