Aaron is a Product Manager for SentryOne. We don't want to say he's old, but his experience dates back to a time when SQL Server 6.5 was considered "modern." He blogs here at sqlperformance.com as well as over at blogs.sentryone.com and sqlblog.org; has been a Microsoft MVP since 1997-98; wrote chapters for two charity-driven books, SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2; and speaks frequently at conferences, user group meetings, and SQL Saturday events around the world.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.
Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.
After a recent conversation on Twitter, Aaron Bertrand (@AaronBertrand) shows where excessive comments in your stored procedures might have an impact on performance.
Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
