12 Ways To Rewrite SQL Queries for Better Performance
Bert Wagner summarizes 12 techniques he's learned over time, from trial and error, for rewriting queries to improve performance.
2019-05-31
Query performance
SQL Server Plan Cache Limits
Erin Stellato explains the limits on both plan cache size, and number of entries. If you’re seeing plan cache bloat due to an ad hoc workload, take note of the space consumed by your plan cache and consider enabling the optimize for ad hoc setting.
2019-05-31
Scalar Functions with Query Plans: Not all is obvious!
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
919 reads
Monitor Query Performance Using Query Store in SQL Server
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.
2018-04-12
4,214 reads
Techniques For Improving SQL Query Performance - Indexing, Parameterization and Partitioning
You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to find out what's causing the bottleneck, and optimize either the queries used, the table schemata, or both.
2013-09-06
6,400 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers