Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2019-04-15 (first published: 2009-10-06)
This script includes a basic E-Mail Address Validation Routine.
2019-04-15 (first published: 2009-11-18)
Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.
2019-04-15 (first published: 2013-11-08)
Script to test outcome probabilities of the "Monty Hall Paradox".
2019-04-15 (first published: 2009-08-31)
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2019-04-15 (first published: 2009-04-29)
It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!
2019-04-15 (first published: 2014-04-25)
Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.
2019-04-15 (first published: 2010-05-11)
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2019-04-15 (first published: 2012-03-19)
Identify all objects containing unused input parameters.
2019-04-15 (first published: 2012-11-26)
Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.
2019-04-15 (first published: 2009-10-27)