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.
SQL SERVER – Find Count of Table Used in Query From Cache
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.
When was Stored Procedure Last Compiled? – Interview Question of the Week #292
Question: When was Stored Procedure Last Compiled?
Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.
Why SQL Server Doesn’t Give the Memory Back to OS?
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.
SQL SERVER – SQL_NO_CACHE and OPTION (RECOMPILE)
How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.
What is the Difference Between sql_handle and plan_handle?- Interview Question of the Week #269
Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.
SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period
Recently I got a very unique situation where I had to Remove All Query Cached Plans Not Used In Certain Period. Let us learn about that today.