Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.
Continue Reading »Feb 172016
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 »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 062015
SQL Sentry's Aaron Bertrand (@AaronBertrand) examines various impacts on SQL Server – not just disk space – when choosing a GUID as a clustering key.
Continue Reading »Oct 232013
Erin Stellato (@erinstellato) of SQLskills.com shows us why I/O latency or high I/O-related waits are not always indicative of slow storage.
Continue Reading »Sep 262013
Aaron Bertrand (@AaronBertrand) discusses a common requirement, generating random numbers to serve as surrogate keys, and shows how you can avoid the incremental cost of preventing collisions.
Continue Reading »
1
2