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.
In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server.
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.
