For his first guest post on SQLPerformance.com, Bert Wagner describes the pros and cons of join elimination in SQL Server.
Category: T-SQL
Itzik Ben-Gan dissects the Hash Match (Aggregate) algorithm in his latest post in a series on SQL Server optimization thresholds.
Continuing his series on optimization thresholds, Itzik Ben-Gan dives into the costs behind stream aggregates when the data needs to be sorted first.
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.
Aaron Bertrand breathes some new life into his long-running SQL Server series on bad habits and best practices. The latest installment discusses the various impacts of choosing GUIDs over numeric types for keys.
Lori Edwards, SentryOne Training Manager, writes about one of her favorite T-SQL rants in this T-SQL Tuesday #99 blog post.
