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

Category: Query Tuning

Top 1 vs. Row Number

February 13, 2019 Erik Darling 3 Comments

Cruel, Cruel Number One is the loneliest number. Sometimes it’s also the hardest number of rows to get, depending on…

Continue Reading →

Posted in: Execution Plans, Query Tuning, SQL Server

Index Sortables

January 29, 2019 Erik Darling Leave a comment

Yelling and Screaming If you saw my post about parameterized TOPs, one thing you may have immediately hated is the…

Continue Reading →

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

Parameters In TOP Are Sniffed, Too

January 25, 2019 Erik Darling 3 Comments

Thank You For Your Business In yesterday’s post, we looked at how row goals affected performance when data matching our…

Continue Reading →

Posted in: Execution Plans, Query Tuning, SQL Server

Recent Posts

  • Implicit vs Explicit Spools
  • Join Me For Free SQL Server Q&A Every Friday At Noon!
  • How SQL Server Can Handle Complex Queries (Sometimes)

Categories

  • Execution Plans
  • Indexing
  • Office Hours
  • Query Tuning
  • SQL Server
Copyright © 2019 Erik Darling Data