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,729 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
965 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,832 reads
Blogs
Container Limits and SQL Server
Limits in Containers Docker gives you the ability to control a container’s access to...
Inspector V2.6 now available
As always the code can be found here in our github repoWe updated our...
Data Mesh: Centralized ownership vs decentralized ownership
By James-Serra
I have done a ton of research lately on Data Mesh (see the excellent...
Forums
Do You Have ALL the YAML?
Comments posted to this topic are about the item Do You Have ALL the...
Why Power Query as an Activity in Azure Data Factory and SSIS?
Comments posted to this topic are about the item Why Power Query as an...
Azure Blob Store Redundancy
Comments posted to this topic are about the item Azure Blob Store Redundancy
Ask SSC