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
Parallelism in Express

SQL SERVER – Parallelism in Express Edition

August 4, 2021
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server

Recently a client reached out to me with a very interesting question, why is he not able to see the parallelism in Express Edition. Let us discuss today. 

Read More
parallel queries

SQL SERVER – Table Variables, Temp Tables and Parallel Queries

June 7, 2021
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server, SQL Variable, Temp Table

I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.

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
Parallel Queries

List All Parallel Queries – SQL in Sixty Seconds #098

August 12, 2020
Pinal Dave
SQL Video
CPU Scheduler, CPU Threads, Parallel, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.

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
Max Degree

SQL SERVER – Override Server’s Configuration of Max Degree of Parallelism

October 1, 2019
Pinal Dave
SQL Performance
CPU Threads, Parallel, SQL CPU, SQL Scripts, SQL Server, SQL Server Configuration

One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.

Read More

SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries

September 4, 2019
Pinal Dave
SQL Performance
CPU Threads, Parallel, SQL CPU, SQL Scripts, SQL Server

Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check.

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

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

Go to mobile version