Glenn Berry explains several manageability and performance improvements relevant to those of you running SQL Server 2012 and SQL Server 2014.
Category: Performance
Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.
Want to download the slide deck and T-SQL scripts for the presentation Architecture Choices that Impact Performance of Microsoft SQL Server? Get them here!
Microsoft MVP Kevin Kline and Charles Kim, founder of Viscosity North America talk about SQL Server running on Vmware in Ten Surprising Performance Killers on Microsoft SQL Server on this October 12th
Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.
Adaptive Query Processing in SQL Server 2017.
Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.
Kevin Kline provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of SQL Server trace flags.
Guest author Derik Hammer dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
Steve Wright explains a hefty set of Advisory Conditions you can add to SentryOne to help you monitor, diagnose, and optimize SSAS...
Find out what new features have been released for the SentryOne Cloud, including a new Performance Dashboard!
Aaron Bertrand 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.
The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server.
When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.
