June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

One Query Many Plans – SQL in Sixty Seconds #171

June 3, 2021
Pinal Dave
SQL Video
Execution Plan, SQL Cache, SQL in Sixty Seconds, SQL Performance, SQL Server

After the blog post, lots of people asked me it will be more helpful if I can create a video on the same topic of one query many plans.

Read More
different entry

SQL SERVER – Same Result Same Query Plan – Different Entry in Cache

June 2, 2021
Pinal Dave
SQL Performance
Ad Hoc Query, SQL Cache, SQL Scripts, SQL Server

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.

Read More
Count Table in Cache

Count Table in Cache – SQL in Sixty Seconds #149

January 12, 2021
Pinal Dave
SQL Video
Execution Plan, SQL Cache, SQL in Sixty Seconds, SQL Scripts, SQL Server

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.

Read More
Remove Unused

SQL SERVER – Remove Unused Cache MARK_IN_USE_FOR_REMOVAL

January 8, 2021
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Memory, SQL Scripts, SQL Server

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. 

Read More
Find the Count

SQL SERVER – Find Count of Table Used in Query From Cache

January 4, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Scripts, SQL Server

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. 

Read More
Last Compiled

When was Stored Procedure Last Compiled? – Interview Question of the Week #292

September 6, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Cache, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: When was Stored Procedure Last Compiled?

Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.

Read More
memory back

Why SQL Server Doesn’t Give the Memory Back to OS?

June 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL DMV, SQL Memory, SQL Scripts, SQL Server

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.

Read More
Previous 1 2 3 4 5 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version