Aaron Bertrand (@AaronBertrand) follows up on a question from his triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.
Tim Radney (@tradney) of SQLskills.com shows us how we can be proactive in monitoring our I/O subsystems for read/write latency that can affect SQL Server performance.
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
Erin Stellato (@erinstellato) adds another entry to her series on proactive health checks for SQL Server, this time treating database and instance settings.
Tim Radney (@tradney) of SQLskills.com explains SQL Server Agent alerts and how you can stay ahead of the game in terms of performance and event monitoring.
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.
Glenn Berry (@GlennAlanBerry) of SQLskills.com runs down why sequential I/O throughput is critical for many SQL Server tasks, and explains how to avoid artificial bottlenecks by choosing hardware components wisely.
