On Nomenclature, and Execution Plan Plus

Nomenclature, or the science of using words to name things using a logical system, is important since accurate names portray with clarity what the thing does. Recently, there’s been a suggestion, posited by Erin Stellato…

List Recently Created Objects

The code below provides a list of all SQL Server objects created in the past “x” number of days. Dynamic T-SQL is used to construct a query for each database, including system databases. Each query…

Hidden tables in SSMS: detect and create them!

Did you know hidden tables may be lurking in your database? SQL Server Management Studio is a world-class database management toolset, and includes some really great features. Arguably the most-used feature is the Object Explorer…

SQL Server 2000 Books Online Documentation

This simply serves as a repository for the SQL Server 2000 Books Online Documentation, in case Microsoft decides to no longer provide it on their website. To be clear, I’m not suggesting anyone actually use…