Skip to content

Erik Darling Data

SQL Server Consulting, Education, and Training
  • Home
  • About Me
  • Coaching
  • Blog
  • Contact Me
  • FAQ

Blog

Waiting For Deadlocks

December 13, 2019 Erik Darling 1 Comment

Try And Retry I’ll sometimes see people implement retry logic to catch deadlocks, which isn’t a terrible idea by itself.…

Continue Reading →

Posted in: Locking, SQL Server

SQL Server 2019 Memory Grants Are Higher

December 12, 2019 Erik Darling Leave a comment

Because I Got

Continue Reading →

Posted in: Memory Grants, Server Tuning

Greatest, Least, and SQL Server

December 11, 2019 Erik Darling 1 Comment

Spinning Out Of Control It’s sorta kinda pretty crazy when every major database platform has something implemented, and SQL Server…

Continue Reading →

Posted in: SQL Server

All The Problems With Select *

December 10, 2019 Erik Darling Leave a comment

This was originally posted by me as an answer here. I’m re-posting it locally for posterity. The two reasons that…

Continue Reading →

Posted in: SQL Server

Does Parallelism Change Memory Grants?

December 9, 2019 Erik Darling Leave a comment

This was originally posted as an answer by me here, I’m re-posting it locally for posterity Sup? For SQL Server…

Continue Reading →

Posted in: SQL Server

SQL Saturday Washington, DC: One Week To Go!

December 6, 2019 Erik Darling Leave a comment

HELLO GUAM! If you’re planning on attending SQL Saturday Washington, DC, why not play hooky from work and spend the…

Continue Reading →

Posted in: SQL Server

Getting Functions Out Of The Where Clause

December 5, 2019 Erik Darling 3 Comments

Raised Right It seems like every time I check out a server, the query plans are a nightmare. Users are…

Continue Reading →

Posted in: Execution Plans, Query Tuning, SQL Server

Why DATEDIFF Is Weird

December 4, 2019 Erik Darling 1 Comment

All Day If I sent you these three queries and asked you if they’d return 0 or 1, what would…

Continue Reading →

Posted in: SQL Server

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

Announcing My Precon For SQL Saturday Chicago 2020

December 2, 2019 Erik Darling Leave a comment

Deep Dish SQL If you’re in Chicago and heading to SQL Saturday 2020, I’d love to see you at my…

Continue Reading →

Posted in: SQL Saturday

Post navigation

Page 1 of 30
1 2 … 30 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