May 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
Join Type

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

Read More
no work

SQL SERVER – Parallelism and Threads with No Work

April 7, 2021
Pinal Dave
SQL Performance
Execution Plan, Parallel, SQL Operator, SQL Scripts, SQL Server

One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.

Read More
Index Scan

SQL SERVER – Top 1 and Index Scan

April 1, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Operator, SQL Scripts, SQL Server, SQL Top, SSMS

Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.

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

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

Go to mobile version