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
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,411 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
963 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,827 reads
Blogs
Quick Start to Using Influxdb on Macos
By Sheldon Hull
Intro OSS 2.0 is a release candidate at this time, so this may change once...
Error: 8623 - The query processor ran out of internal resources and could not produce a query plan
Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...
Goal Progress– October 2020
By Steve Jones
This is my report, which continues on from the Aug report. After that report,...
Forums
What is Possible?
Comments posted to this topic are about the item What is Possible?
I cannot add a replica because of difference between instances
Hi There, Let me start with to say I am not a SQL administrator,...
Tip for getting trifocals made for computer monitor use.
I want to share with those of you advancing in years something I learned...
Ask SSC