Feb 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
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
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
slow performance

SQL SERVER – Top Reasons for Slow Performance

February 10, 2020
Pinal Dave
SQL Performance
Ad Hoc Query, Clustered Index, Disk, File Growth, Query Hint, SQL CPU, SQL DMV, SQL Function, SQL Index, SQL Memory, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL TempDB, SQL Utility

Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.

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
Recompiling Query

SQL SERVER – Performance and Recompiling Query – Summary

January 1, 2020
Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Stored Procedure

I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.

Read More
recompile

SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)

December 31, 2019
Pinal Dave
SQL Tips and Tricks
Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.

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

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

Go to mobile version