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)
16,837 reads
2019-04-15 (first published: 2009-11-18)
2,064 reads
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)
7,174 reads
2019-04-15 (first published: 2009-08-31)
1,294 reads
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)
5,026 reads
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)
8,384 reads
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)
16,000 reads
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)
6,707 reads
2019-04-15 (first published: 2012-11-26)
3,390 reads
2019-04-15 (first published: 2009-10-27)
15,551 reads
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Comments posted to this topic are about the item You Have Homework
Hello all, I am having one heck of a time installing Microsoft Connector for...
hi, a peer of mine would like to be self sufficient in bringing small...
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers