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,689 reads
2019-10-28
6,344 reads
2019-06-10
1,081 reads
2019-05-24
Batch Cussidy In the last post, we looked at how S...
2019-05-24
Watch this week’s episode on YouTube. SQL Server...
2019-05-22
2019-05-22
Footnote I have two queries. They return the same number of rows. The only difference is one column in the…
2019-05-20
Two Words Alright, I’ve lied to you already. There are way more than two words involved, here. I recently had…
2019-05-15
Last week in our IEPTO2 class I was asked about queries with RECOMPILE and Query Store. Specifically: Do queries that have the OPTION (RECOMIPLE) hint go into Query...
2019-05-14
One of the nice things about the Microsoft Connector for Oracle is that it...
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
I've been looking for a way to change multiple data sources for reports to...
Comments posted to this topic are about the item Azure SQL Revealed: A Guide...
Comments posted to this topic are about the item Refresh Limits
Ask SSC