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.
2015-11-16
3,593 reads
Articles
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.
2015-11-13
2,571 reads
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.
2015-11-12
3,041 reads
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.
2015-11-12
8,610 reads
2015-11-11
232 reads
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.
2015-11-11 (first published: 2015-01-12)
7,760 reads
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.
2015-11-11
3,177 reads
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.
2015-11-10
1,136 reads
Introduction to PolyBase in SQL Server 2016 - Part 1
One of the features introduced in SQL Server 2016 is PolyBase. The goal of PolyBase is to make interacting with unstructured, semi-structured and non-relational data stored in Hadoop as easy as writing Transact-SQL statements. Edwin Sarmiento explains.
2015-11-10
3,022 reads
How to Add a Drive as a Clustered Physical Disk Resource in Windows
This article is covers how to add a drive as a Clustered Physical Disk Resource in Windows 2003.
2015-11-09
6,647 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
What is Page Density
Comments posted to this topic are about the item What is Page Density
T-SQL in SQL Server 2025: Fuzzy String Search II
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Azure-SSIS, Self-Hosted Integration Runtime, & Data Gateway?
Looking to confirm my understanding of these three products and how they can be...
Question of the Day
What is Page Density
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers