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,548 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 kleegeek
Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...
Tencent Security has released a report (written in Chinese) describing a new malware attack by...
By James-Serra
There are some options in Azure Synapse Analytics that are not obvious that I...
Please forgive me for asking questions about licensing on older version SQL servers We...
Comments posted to this topic are about the item The Last Compile Time
Comments posted to this topic are about the item Incremental Data Loading using Azure...
Ask SSC