Multiple DISTINCT Aggregate Performance In SQL Server

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

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

A Little About Loops In Dynamic SQL

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

In Memory Table Variables In SQL Server: Still Pretty Stupid

Signs You Need Dynamic SQL In Your SQL Server Queries

A Foreign Key Join Elimination Limitation In SQL Server

When To Use DBCC DROPCLEANBUFFERS When You're Tuning SQL Server Queries

Annoyances With Filtered Indexes And Computed Columns In SQL Server

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

A Little About Index Compression In SQL Server

A Little About Index Sort Direction In SQL Server

Multiple DISTINCT Aggregate Performance In SQL Server

"SARGable" Sorting and Grouping In SQL Server

Performance Tuning TOP PERCENT Queries In SQL Server

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

So You Want To Implement Soft Deletes In SQL Server

One Way To Track Row Changes In Place In SQL Server

Making It Easy To Tell When Data Changed With Change Data Capture In SQL Server

Five Reasons Why Your SQL Server Is Slow Right Now

Data Saturday Dallas Promo Video

A Little About Out Of Date Statistics In SQL Server

A Little About Filtering On Dates In SQL Server

A Little About Filter Operators In SQL Server Query Plans