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,781 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,486 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
1,015 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,879 reads
Blogs
Installing and Configuring containerd as a Kubernetes Container Runtime
This post shows you how to install containerd as the container runtime for Kubernetes...
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Forums
Alamat Telp BCA KCP Citra 2 Ext +62 838-4945-0961
Wa:083849450961 Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02,...
Alamat BCA KCP Duta Gardenia +62 838-4945-0961
Wa:083849450961 Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda,...
Layanan Resmi BCA KCU A. YANI Telp:0821°8200°203
Telp/Wa 628218200203 Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers