Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.
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.
Tim Radney (@tradney) of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue.
Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.
