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 152016
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 »Sep 102013
Erin Stellato (@erinstellato) of SQLskills discusses partitioning and explains how it is not always a magic turbo button for improving query performance.
Continue Reading »Jul 302013
Erin Stellato (@erinstellato) talks about the implications of holding onto data, beyond its reasonable lifetime, in monolithic, single-partition tables.
Continue Reading »Jul 262013
SQL Sentry's Aaron Bertrand (@AaronBertrand) reflects on the presentation he gave during the PASS Performance VC Summer Performance Palooza 2013 on June 27th, including a wealth of responses to Q & A.
Continue Reading »
1
2