Slow reports, slow transactions, and the internal team could not find why. In this case study, MAXDOP = 1 was quietly slowing down the entire business.
SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).
Configuring Parallel Index Operations in SQL Server
Configuring parallel index operations in SQL Server can significantly impact query performance and scalability. During my popular service, we discuss.
3 Ways to Configure MAXDOP – SQL in Sixty Seconds #166
We will see a quick SQL in Sixty Seconds video and scripts used in the video to change MAXDOP. Let us watch 3 Ways to Configure MAXDOP.
SQL SERVER – 3 Different Ways to Set MAXDOP
I got lots of emails about how to set MAXDOP for any query. Today we will be learning 3 different ways to set MAXDOP. Let us learn it today.
SQL SERVER – Stream Aggregate and Hash Aggregate
Recently during the on-demand consultation, I was asked a very interesting question about Stream Aggregate and Hash Aggregate.
SQL SERVER – Best Practices for Dynamics NAV AX CRM
In the last 3 months, I have done nearly 11 consulting engagement for Dynamics NAV AX CRM while working on Comprehensive Database Performance Health Check.