Skip to content
Erik Darling Data
SQL Server Consulting, Education, and Training
  • Home
  • About Me
  • Coaching
  • Blog
  • Contact Me
  • FAQ

Category: Indexing

Index Spools When You Have An Index

December 3, 2019 Erik Darling 1 Comment

PAUL WHITE IS WRONG Ha ha. Just kidding. He’s never wrong about anything. But he did write about Eager Index…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, SQL Server

But I Need To Compare Two Date Columns In Different Tables

November 28, 2019 Erik Darling Leave a comment

A Certain Ratio I have a lot to say about this demo on SQL Server 2019, which I’ll get to…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, SQL Server

But I Need To Compare Two Date Columns In My Where Clause

November 27, 2019 Erik Darling 8 Comments

Tell It To The Judge A common dilemma is when you have two date columns, and you need to judge…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, SQL Server

Where To Do Date Math In Your Where Clause

November 26, 2019 Erik Darling 3 Comments

Pattern Baldness I see this pattern quite a bit in stored procedures, where the front end accepts an integer which…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, SQL Server

Getting Smart About Fixing Key Lookups

October 14, 2019 Erik Darling 2 Comments

Unavoidable Having some key lookups in your query plans is generally unavoidable. You’ll wanna select more columns than you wanna…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, SQL Server

How Unused Indexes Hurt: Lock Escalation

October 10, 2019 Erik Darling 1 Comment

Facts Yesterday we looked at how unused indexes can muck up the buffer pool, because writes to them will bring…

Continue Reading →

Posted in: Indexing, Locking, SQL Server

How Unused Indexes Hurt: Buffer Pool

October 9, 2019 Erik Darling Leave a comment

Lost In The Woods When you find unused indexes, whether using Some Script From The Internetâ„¢, sp_BlitzIndex, or Database Telepathy,…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, SQL Server

Indexes: Quality, Quantity, and You

September 4, 2019 Erik Darling Leave a comment

To Taste Indexes remind me of salt. And no, not because they’re fun to put on slugs. More because it’s…

Continue Reading →

Posted in: Indexing

The Hardest Part Of Query Tuning: Logical Equivalence

August 13, 2019 Erik Darling 1 Comment

Grey Matter Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.…

Continue Reading →

Posted in: Execution Plans, Indexing, Joe Obbish, Query Tuning, SQL Server

Does SQL Server Choose Multiple Indexes Based On Selectivity?

August 8, 2019 Erik Darling 3 Comments

Will Travel If you recall yesterday’s post, we added a couple two column indexes to the Posts table. Each one…

Continue Reading →

Posted in: Execution Plans, Indexing, Query Tuning, Server Tuning

Post navigation

Page 1 of 3
1 2 3 Next →

Recent Posts

  • Waiting For Deadlocks
  • SQL Server 2019 Memory Grants Are Higher
  • Greatest, Least, and SQL Server

Categories

  • Accelerated Database Recovery
  • Batch Mode
  • Bugs
  • CHECKDB
  • columnstore
  • Dynamic SQL
  • Execution Plans
  • FROID
  • Indexing
  • Isolation Levels
  • Joe Obbish
  • Locking
  • Memory Grants
  • Office Hours
  • OPTIMIZE_FOR_SEQUENTIAL_KEY
  • Parallelism
  • Parameter Sniffing
  • perfview
  • Plan Cache
  • Query Tuning
  • Server Tuning
  • Spills
  • SQL Saturday
  • SQL Server
  • SQLBits
  • Stack Column Store
  • Statistics
  • tempdb
  • Training
  • Triggers
  • Wait Stats
Copyright © 2019 Erik Darling Data