Aaron Bertrand (@AaronBertrand) continues his series on widening an IDENTITY column, showing how he would attack the problem directly.
Continue Reading »Aug 042016
Jun 102016
Rob Farley (@rob_farley) digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
Continue Reading »Jun 022016
Rob Farley (@rob_farley) looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Continue Reading »May 102016
For T-SQL Tuesday #78, Aaron Bertrand (@AaronBertrand) takes a look at whether RID Lookups are faster than Key Lookups, with a small battery of fairly simple duration tests.
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 »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 »