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.
Erin Stellato (@erinstellato) of SQLskills continues her series on proactive SQL Server health checks, this time focusing on mastering maintenance tasks.
Erin Stellato (@erinstellato) of SQLskills kicks off a series on proactive SQL Server health checks, explaining how she handles disk space management for customers.
Glenn Berry (@GlennAlanBerry), of SQLskills, shows how to get the most bang for your buck if you plan to run SQL Server 2014 on an Azure virtual machine.
Aaron Bertrand (@AaronBertrand) walks through several potential causes for different plans and/or performance for the same database on two "identical" servers.
Continuing his knee-jerk series, this time Paul Randal (@PaulRandal) of SQLskills talks about SSDs, and some of the false impressions people get about them.
Erin Stellato (@erinstellato) of SQLskills explains another reason she avoids the built-in sp_updatestats procedure: it doesn't consider indexed views.
Aaron Bertrand (@AaronBertrand) shows some tricks for getting row counts efficiently, and explains why an accurate row count for a large table is a pipe dream.
Paul Randal (@PaulRandal talks about Page Life Expectancy – what it is, why fixed thresholds are meaningless, when it matters, and what you can do about it – in this latest installment of his "knee-jerk troubleshooting" series.