Aaron Bertrand gives some scattered thoughts about how he has contributed to the SQL Server community throughout his career.
For his first post on SQLPerformance.com, Itzik Ben-Gan shows you how to reverse engineer optimizer costing for a Stream Aggregate operator.
Two of our favorite Andys are gearing up for this weekend's #SQLSatMadison. Here Andy Yun talks about the event, the sessions that he will be presenting, and also talks about Andy Mallon's session.
Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance.
Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule.
Don't take SQL Server Missing Index recommendations at face value. They have numerous limitations. In this blog post, Andy Yun explores one of these: Index Key Order.
Lori Edwards, SentryOne Training Manager, writes about one of her favorite T-SQL rants in this T-SQL Tuesday #99 blog post.
In this month's T-SQL Tuesday post, Allen shares his passion for performing, leading to his performance in January with the Cleveland Orchestra at Carnegie Hall.
Aaron Bertrand addresses the questions raised during two parameter sniffing webinars in January with Kimberly L. Tripp and Andy Mallon.
Want to download the slide deck and T-SQL scripts for the presentation "Architecture Choices that Impact Performance of Microsoft SQL Server?" Get them here!
Jason Hall gives a technical walk-through of one of his favorite use cases for Plan Explorer : troubleshooting application and Entity Framework code.
Lori Edwards shares about "Folks Who Have Made a Difference" in this T-SQL Tuesday blog post.
Paul White discusses the pros and cons of maintaining three-character substrings (trigrams) to speed up wildcard searches. Continue reading…
Andy Mallon (@AMtwo) walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM.