Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.
SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications
SafePeak caches query and procedure results in memory to speed up 3rd party applications on SQL Server without code changes. Here is my take on it.
SQLAuthority News – Online Session Practical Tricks and Tips to Speed up Database Queries Today
Today at Virtual Tech Days I share practical tricks and tips to speed up database queries, plus a fun game: count how often I say performance.
SQL SERVER – A Quick Look at Performance – A Quick Look at Configuration
Before I answer a performance question, I need to know the environment. Here is how I take a quick look at configuration to get the full picture fast.
SQLAuthority News – Virtual Presentation on Practical Tricks and Tips to Speed up Database Queries – December 15, 2011
On December 15, 2011 at Virtual Tech Days I present practical tricks and tips to speed up database queries, from Denali T-SQL to timeless best practices.
SQLAuthority News – SafePeak’s SQL Server Performance Contest – Winners
SafePeak announced the winners of its SQL performance contest 2011. Jason Brimhall wrote the best performance story, and here are all the winners.
What Is In the Plan Cache and How to Look
Inspect the SQL Server plan cache, identify single-use plans and memory use, and understand what optimize for ad hoc workloads changes.