Paul Randal (@PaulRandal) continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
Continue Reading »Apr 062016
Mar 182016
SQL Server 2016 RC0 introduces a new native string splitting function, STRING_SPLIT. Aaron Bertrand (@AaronBertrand) compares its performance to existing methods.
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.
Continue Reading »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 »