Erik Darling

The Unpredictability Of SQL Server Performance

Why Read Committed Queries Can Still Return Bad Results In SQL Server

The Difference Between Read Committed And Read Committed Snapshot Isolation In SQL Server

SQL Server Index Design: Getting Key Column Order Right

sp_QuickieStore: Now Handling The Biggest XML

sp_QuickieStore: Find Your Worst Performing Queries During Working Hours

Loops, Transactions, and Transaction Log Writes In SQL Server

The Unpredictability Of SQL Server Performance

Rewriting Multi Statement Table Valued Functions

Efficiently Finding Aggregate Values In SQL Server: Row Mode vs Batch Mode vs Indexes!

Rewriting Scalar UDFs As Inline Table Valued Functions With CTEs

How Indexes Talk To Each Other In SQL Server

A Little About PAGEIOLATCH Waits In SQL Server

A Little About Sorts In SQL Server Query Plans

A Little About Nested Loops, Parallelism, and the Perils of Recursive Common Table Expressions

Plan Cache Pollution From Temporary Objects In SQL Server

A Very Silly Performance Tuning Trick In SQL Server

Read Committed Is A Garbage Isolation Level

How To Evaluate Index Effectiveness While Tuning SQL Server Queries

Error Handling In Cursors

Be Careful When You Alter Indexed Views

02 Table Variables

Why You Probably Dont Want ISNULL Or COALESCE In Your SQL Server Queries

A Little About Local Variables In SQL Server

How I Use sp_BlitzFirst To Profile SQL Server

Five Reasons Why Your SQL Server Is Slow Right Now

Data Saturday Dallas Promo Video

A Difference Between ISNULL And COALESCE You Might Care About In SQL Server

SARGable Sorting and Grouping In SQL Server

Multiple DISTINCT Aggregate Performance In SQL Server

A Little About Filtering On Dates In SQL Server

A Bug When Mixing datetime and datetime(2) Data Types

One Way To Track Row Changes In Place In SQL Server

A Little About Loops In Dynamic SQL

When To Use DBCC DROPCLEANBUFFERS When Youre Tuning SQL Server Queries

Performance Tuning TOP PERCENT Queries In SQL Server

Annoyances With Filtered Indexes And Computed Columns In SQL Server

A Little About Index Sort Direction In SQL Server

A Little About Computed Columns, Filtered Indexes, and Indexed Views in SQL Server

Troubleshooting Security Cache Growth In SQL Server (USERSTORE_TOKENPERM And TokenAndPermUserStore)

In Memory Table Variables In SQL Server: Still Pretty Stupid

A Little About Out Of Date Statistics In SQL Server

Query Plan Patterns For Windowing Functions: Row Mode vs Batch Mode

A Foreign Key Join Elimination Limitation In SQL Server

A Little About Index Compression In SQL Server

Signs You Need Dynamic SQL In Your SQL Server Queries

So You Want To Implement Soft Deletes In SQL Server

A Little About Filter Operators In SQL Server Query Plans

Why Expressions Are Better Than Local Variables For Performance In SQL Server

Why SQL Servers ROWLOCK Hint Doesnt Always Just Lock Rows

A Little About Indexed View Maintenance In SQL Server