Hash Joins on Nullable Columns
Paul White explores some less well-known query optimizer features and limitations, and explains the reasons for extremely poor hash join performance in a specific case.
Capture Execution Plan Warnings using Extended Events
Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
How to Install and Configure Baseline Collector Solution V2
In this article I go through the installation and configuration processes of my Baseline Collector Solution.
Automating Your SQL Server Best Practice Reports: The Document
If you're making a report from table-based data, an MS Word document is often a good option. In the second part of his introduction to SQL Server best-practice monitoring, Laerte Junior shows how to use PowerShell scripts to create a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.
SQL Prompt Tips #5 - Current Statement Execution
Learn how a new feature in SQL Prompt 6.4 can help you avoid costly mistakes in coding.
Extended Statistics and Oracle 12c
David Fitzjarrell looks at how and why to use a feature called Automatic Column Group Detection to recognize column dependencies and create extended statistics on recognized groups in Oracle 12.1.0.2.
Add Dependencies to a SQL Server Resource in Windows 2003
In this article, see how to add a dependency to a SQL Server Resource in a Windows 2003 cluster.
Do You Have Scary Code?
Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers