Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. 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.sqlsentry.com and sqlblog.com; 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.

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Posted by Aaron Bertrand on April 19, 2016 No Responses »

Apr 192016

Aaron Bertrand (@AaronBertrand) follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.

Performance Surprises and Assumptions : DATEADD()

Posted by Aaron Bertrand on April 11, 2016 7 Responses »

Apr 112016

Aaron Bertrand (@AaronBertrand) explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.

Performance Surprises and Assumptions : STRING_SPLIT()

Posted by Aaron Bertrand on March 18, 2016 11 Responses »

Mar 182016

SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.

Instant File Initialization : Impact During Setup

Posted by Aaron Bertrand on March 11, 2016 5 Responses »

Mar 112016

SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand (@AaronBertrand) looks at how this can impact tempdb data file creation.

Bad cardinality estimates from SSMS plans – redux

Posted by Aaron Bertrand on March 4, 2016 4 Responses »

Mar 042016

Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.

Performance Surprises and Assumptions : SET NOCOUNT ON

Posted by Aaron Bertrand on February 26, 2016 29 Responses »

Feb 262016

Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.

Minimizing impact of widening an IDENTITY column – part 3

Posted by Aaron Bertrand on February 17, 2016 3 Responses »

Feb 172016

Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.

1 2 3 … 15 16