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
disable adaptive

SQL SERVER – Disable Adaptive Joins

March 30, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Scripts, SQL Server

My client sent me an interesting scenario where a query with adaptive join was performing badly. Let us learn how to disable adaptive joins. 

Read More
Adaptive Join

SQL SERVER – Enable Adaptive Join

March 26, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Scripts, SQL Server

Let us learn how we can enable the adaptive join feature in SQL Server. I often discuss this during Comprehensive Database Performance Health Check.

Read More
Adaptive Threshold Rows

SQL SERVER – Adaptive Threshold Rows

March 25, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Scripts, SQL Server

Today we are going to learn about what drives the decision to join Adaptive Join. Well, the answer is very simple – Adaptive Threshold Rows.

Read More
find a table

Find a Table in Execution Plan – SQL in Sixty Seconds #151

January 27, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.

Read More
find a table

SQL SERVER – Find a Table in Execution Plan

January 25, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Server, SQL Server Management Studio, SSMS

Of course yes, we can easily find a table in the execution plan with the Find Node feature of SSMS (SQL Server Management Studio).

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
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
Previous 1 2 3 4 5 6 7 8 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version