Skip to content

Erik Darling Data

SQL Server Consulting, Education, and Training

Erik Darling Data
  • Blog
  • Learn
    • Pre-Recorded Classes
    • In-Person Events
  • Scripts
    • sp_HumanEvents
    • sp_PressureDetector
  • Contact
  • Request a Call

Category: Plan Cache Liars

Signs Your Execution Plan Is Lying To You: Cached Temp Tables

Posted on March 6, 2020February 15, 2020 by Erik Darling

Ain’t No Stress On Me


Posted in Plan Cache Liars, SQL ServerLeave a Comment on Signs Your Execution Plan Is Lying To You: Cached Temp Tables

Signs Your Execution Plan Is Lying To You: Startup Expressions

Posted on February 18, 2020February 18, 2020 by Erik Darling

You’ll Go Blind


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Startup Expressions

Signs Your Execution Plan Is Lying To You: Batch Costs

Posted on February 17, 2020January 2, 2020 by Erik Darling

Batchered


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Batch Costs

Signs Your Execution Plan Is Lying To You: Operator Costs

Posted on February 14, 2020January 2, 2020 by Erik Darling

Pennywise


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Operator Costs

Signs Your Execution Plan Is Lying To You: Spills and Memory Grants

Posted on February 13, 2020January 2, 2020 by Erik Darling

Milky


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Spills and Memory Grants

Signs Your Execution Plan Is Lying To You: Nested Loops

Posted on February 12, 2020January 2, 2020 by Erik Darling

Hellish


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Nested Loops

Signs Your Execution Plan Is Lying To You: Merge Joins

Posted on February 11, 2020January 2, 2020 by Erik Darling

Mergin’ Around


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Merge Joins

Signs Your Execution Plan Is Lying To You: Sub Executions

Posted on February 10, 2020January 2, 2020 by Erik Darling

What It Did?


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Sub Executions

Signs Your Execution Plan Is Lying To You: Repartition Streams

Posted on February 7, 2020January 2, 2020 by Erik Darling

Steakenly


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Repartition Streams

Signs Your Execution Plan Is Lying To You: Exchange Spills

Posted on February 6, 2020January 2, 2020 by Erik Darling

Since They Wanna Know


Posted in Plan Cache LiarsLeave a Comment on Signs Your Execution Plan Is Lying To You: Exchange Spills

Posts navigation

Older posts

Recent Posts

  • Common Query Plan Patterns For Joins: Index Intersection
  • Common Query Plan Patterns For Joins: No Equality Predicate
  • Common Query Plan Patterns For Joins: DOP and Bitmaps

Subscribe

Categories

  • Accelerated Database Recovery
  • Angry Aggregates
  • Batch Mode
  • Bugs
  • Cardinality
  • Change Data Capture
  • CHECKDB
  • Cider
  • columnstore
  • Common Query Plan Patterns
  • Cursors
  • Deadlock
  • Dynamic SQL
  • Execution Plans
  • Extended Events
  • FROID
  • Hardware
  • Indexing
  • Interviewing
  • Isolation Levels
  • Joe Obbish
  • Locking
  • Memory Grants
  • Office Hours
  • OPTIMIZE_FOR_SEQUENTIAL_KEY
  • Parallelism
  • Parameter Sniffing
  • Parameterization
  • Partitioning
  • perfview
  • Plan Cache
  • Plan Cache Liars
  • Plan Guides
  • Query Store
  • Query Tuning
  • Server Tuning
  • sp_HumanEvents
  • sp_PressureDetector
  • sp_WhoIsActive
  • Spills
  • SQL Saturday
  • SQL Server
  • SQL Server 2019
  • SQLBits
  • SSMS
  • Stack Column Store
  • Starting SQL
  • Statistics
  • Streaming
  • T-SQL
  • Tasting Menu
  • tempdb
  • Training
  • Triggers
  • Wait Stats
Copyright © 2019 Erik Darling Data