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.
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.
Learn about SQL Server pagination, including what it is, best practices, and how to fetch data better by optimizing queries that use OFFSET/FETCH pagination.