Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.
Tim Radney (@tradney) of SQLskills talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.
Tim Radney of SQLskills gives an overview of his approach to SQL Server performance tuning, from system configuration, to I/O latency, to high cost queries.
Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
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.
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.
Aaron Bertrand (@AaronBertrand) walks through several potential causes for different plans and/or performance for the same database on two "identical" servers.
