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 »Feb 172016
Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.
Continue Reading »Feb 112016
Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from int to bigint, detailing several challenging obstacles.
Continue Reading »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.
Continue Reading »Jan 292016
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 222016
Aaron Bertrand (@AaronBertrand) compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.
Continue Reading »