As part of a new series, Aaron Bertrand takes a look at what happens to the structure of a page when an INT column needs to be upsized to a BIGINT.
Continue Reading »Jan 292016
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 »Jan 062016
Tim Radney of SQLskills gives an overview of his approach to SQL Server performance tuning, from system configuration, to I/O latency, to high cost queries.
Continue Reading »