February 2016 - SQLPerformance.com

Performance Surprises and Assumptions : SET NOCOUNT ON

Posted by Aaron Bertrand on February 26, 2016 26 Responses »

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.

Minimizing impact of widening an IDENTITY column – part 3

Posted by Aaron Bertrand on February 17, 2016 3 Responses »

Feb 172016

Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.

Minimizing impact of widening an IDENTITY column – part 2

Posted by Aaron Bertrand on February 11, 2016 2 Responses »

Feb 112016

Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from int to bigint, detailing several challenging obstacles.

Sparse Columns in SQL Server : Impact on Time & Space

Posted by Erin Stellato on February 5, 2016 No Responses »

Feb 052016

Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.