Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Continue Reading »Mar 042016
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.
Continue Reading »Jan 222016
Aaron Bertrand (@AaronBertrand) compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.
Continue Reading »Jan 152016
Aaron Bertrand (@AaronBertrand) revisits an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance.
Continue Reading »Oct 082015
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.
Continue Reading »Sep 222015
SQL Sentry's @AaronBertrand adds a few tidbits to follow up on his popular post on default cursor options in SQL Server.
Continue Reading »Jul 152015
Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.
Continue Reading »