The question I was asked was about a query that had the same result same query plan but the different entry in the cache, is that possible.
Today’s topic is very unique and one should not try it out without the proper consultation of an expert. How to Remove Unused Cache MARK_IN_USE_FOR_REMOVAL.
we had an interesting situation where we wanted to Find the Count of Table Used in Query From Cache. Let us see how we can do that in today’s blog post.
Question: When was Stored Procedure Last Compiled?
Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.
Today’s post is written by SQL Server Expert Brian Gale. Why SQL Server Doesn’t Give the Memory Back to OS? Let us learn an amazing concept.