Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.
Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.
Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.
When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.
Erin Stellato (@erinstellato) discusses the types of performance data needed to help with capacity planning.
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.
Kevin Kline (@kekline) answers several questions from his recent webinar on I/O latency with Tegile's Sumeet Bansal.
Kevin Kline (@kekline) continues his series on troubleshooting SQL Server; in this post, he shows how to correlate wait stats to other system metrics.
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.