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
goal optimizer

SQL SERVER – Disable Rowgoal Optimizer

December 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?

Read More
Rows Read

SQL SERVER – Number of Rows Read – Execution Plan

December 25, 2020
Pinal Dave
SQL Performance
Clustered Index, Execution Plan, SQL Index, SSMS

Recently one of the clients sent me images from the execution plan and his question was about the Number of Rows Read in the SQL Server Execution plan.

Read More
Running

Slow Running Query – SQL in Sixty Seconds #146

December 11, 2020
Pinal Dave
SQL Video
Execution Plan, SQL DMV, SQL in Sixty Seconds

One of the most popular questions I receive during Comprehensive Database Performance Health Check is if I have a script that lists Slow Running Query.

Read More
long running queries

SQL SERVER – Long Running Queries with Execution Plan

December 7, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.

Read More
JOIN Elimination

SQL SERVER – JOIN Elimination for Not Selected Column

November 25, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Statistics, SSMS

The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.

Read More
16 CPU

SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142

November 10, 2020
Pinal Dave
SQL Video
CPU Threads, Execution Plan, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.

Read More
multiple param

SQL SERVER – Multiple Optimize Hint for a Query

November 6, 2020
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, Query Hint, SQL Scripts, SQL Server

An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.

Read More
Previous 1 … 3 4 5 6 7 8 9 … 18 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version