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,713 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,410 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
959 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,824 reads
Blogs
Graph – Shortest Path
‘Shortest path’ is by far the most feature of SQL Graph for now. What...
Last Week Reading (2019-09-22)
By Kamil
Hello #datafolks! Let’s review what happened last week in Data World. It’s hard to...
Simple Graph Queries
In this post we saw how to create some graph tables with data. In...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
memory not getting released to OS
Hi All, Need help here. Why is sql server is not releasing memory to...
Will the principal wait for acknowledgement from mirror?
Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....
Ask SSC