The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance...

Thanks to everyone who attended my 24 Hours of PASS session, The Data Loading Performance Presentation. It was a lot of fun taking part...

Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun. SQLRally On...

New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most. I...

Views, table variables and local variables are great in terms of programming principles. But In terms of performance, they can be a honey...

I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”. I was amazed by the...