Minimizing impact of widening an IDENTITY column – part 1 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. Aaron Bertrand ◆ January 29, 2016 3
Comparing string splitting / concatenation methods Aaron Bertrand (@AaronBertrand) compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string. Aaron Bertrand ◆ January 22, 2016 14
Can ColumnStore Help Pagination Workloads? Aaron Bertrand (@AaronBertrand) revisits an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance. Aaron Bertrand ◆ January 15, 2016 1
Tuning : A Good Place to Start 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. Tim Radney ◆ January 6, 2016 0
