Aaron is a Staff Database Reliability Engineer at Stack Overflow. 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 writes here at sqlperformance.com, over at sqlblog.org, and at MSSQLTips.
Aaron Bertrand (@AaronBertrand) walks through several potential causes for different plans and/or performance for the same database on two "identical" servers.
Aaron Bertrand (@AaronBertrand) shows some tricks for getting row counts efficiently, and explains why an accurate row count for a large table is a pipe dream.
Aaron Bertrand (@AaronBertrand) demonstrates an affordable approach to readable secondaries, without the need for Availability Groups and all the licensing costs involved with Enterprise Edition and Software Assurance.
Aaron Bertrand (@AaronBertrand) discusses examples where people expect SQL Server to perform tasks that really should be performed outside the scope of the database.
Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.
Following the recent release of SQL Server 2012 Service Pack 2 and SQL Server 2014 Cumulative Update #3, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag (2453) aimed at improving cardinality estimates for table variables and table-valued parameters.
