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
Fixed Plan

SQL SERVER – Reducing TempDB Recompilation with Fixed Plan

March 11, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Scripts, SQL Server, SQL TempDB

Let us talk about how we were able to reduce tempdb recompilation with Fixed Plan while working on Comprehensive Database Performance Health Check.

Read More

SQL SERVER – Remove All Query Cached Plans Not Used In Certain Period

March 7, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server DBCC

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. 

Read More
show status

MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’

February 20, 2020
Pinal Dave
SQL Tips and Tricks
Execution Plan, MySQL

One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.

Read More
Stream Aggregate

SQL SERVER – Stream Aggregate and Hash Aggregate

February 17, 2020
Pinal Dave
SQL Performance
Execution Plan, MAXDOP, Parallel, Query Hint, SQL Group By, SQL Operator, SQL Server Management Studio, SSMS

Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.

Read More
fast N

SQL SERVER – OPTION(FAST N) Hint and Performance

February 11, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Scripts, SQL Server

I have a very interesting situation while working with SQL Server 2019, which I had not faced before about OPTION(FAST N).

Read More
row goal

SQL SERVER – Row Goal and Performance

February 7, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, Row Goal, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

During the recent consulting engagement of SQL Server 2017/2019, my client asked me if I can help them enable the new feature of Row Goal.

Read More
RID Lookup

SQL SERVER – Heaps, Scans and RID Lookup

January 25, 2020
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Heap, SQL Index, SQL Scripts, SQL Server

The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.

Read More
Previous 1 … 7 8 9 10 11 12 13 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version