How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples

This article describes the N+1 problem that we often find when developers use row by row solutions for querying related data in a database.

The Complexity of Metrics

We need to monitor our servers, but individual metrics have more complexity than just setting simple limits for their readings.

Query Tuning, Why Bother?

Today Grant wonders why we spend so much time trying to learn about query tuning.

The Plan Cache Plan

Diagnose and resolve latch contention on SQL Server

This guide describes how to identify and resolve latch contention issues observed when running SQL Server applications on high concurrency systems with certain workloads.

More on Column Choice and Order for Multi-column Non-Clustered Indexes

In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]

Performance Tuning Means 3 Things

Brent Ozar discusses performance tuning and how From the outside it looks more complicated than it is, but at the end of the day, it always comes back to just 3 knobs and knowing which ones you can turn.

A Self-Tuning Fill Factor Technique for SQL Server – Part 2

Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexes within a database. Part 2 covers an analysis of the data collection […]

Waits and Queues

This week Steve is wondering if you know how to use waits and queues for troubleshooting.

A Self-Tuning Fill Factor Technique for SQL Server – Part 1

Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in April at SQL Saturday #830 - Colorado Springs, I attended two sessions by […]