Glenn Berry (@GlennAlanBerry) of SQLskills.com encourages us to start looking at benefits we'll see from upcoming changes to Intel processors, Windows 10, and SQL Server vNext.
Continue Reading »Jan 272015
Jan 232015
Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.
Continue Reading »Jan 122015
Aaron Bertrand (@AaronBertrand) shows how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.
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 »