A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the queries were in the format select * […]
2019-11-11
4,532 reads
Imagine it. You've been asked to fix a dire performance problem with a SQL Server database. You find a severe case of 'Cache Bloat' due to ad-hoc queries, but you can't fix the code itself. What should you do? Specify forced parameterization? Perhaps a better idea would be to use guide plans.
2014-03-04
2,646 reads
By Daniel Janik
On a few occasions I’ve referred to GCP (Google Cloud Platform) as the “Windows...
By James-Serra
On the heels of More Azure Blob Storage enhancements come more enhancements for Azure...
I asked this question myself: Is there a way to use Extended Events to...
Comments posted to this topic are about the item Availability Groups with Docker Containers
Today’s tip is to think of something you’ve always wanted to do and never...
I need to write a query which will first update the table, then execute...
Ask SSC