Earlier I had written a blog post about SQL SERVER – Find Count of Table Used in Query From Cache. Today we will see a video for the same.
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.
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.