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) asks you to vote for and, more importantly, comment on a Connect item aimed at adding MAXDOP controls to statistics updates.
With additional tests comparing splitting techniques to TVPs, Aaron Bertrand (@AaronBertrand) rounds out his series on STRING_SPLIT() in SQL Server 2016.
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.
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.
Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.
