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,706 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
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
You can find the slides for my session at Future Data Driven summit at...
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Contact us today to discuss About Smtp: - Smtp service provider with good inboxing...
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
Hello, I am trying to split data, looks like there is some special...
Ask SSC