SQL Server Performance Tuning Expert frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Expert frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQL SERVER – Update Table Statistics in Parallel with FULLSCAN

SQL Server Performance Tuning is a much simpler job if you know exactly where to look for and how to tune the configurations. Here is the real world scenario which I encountered during the recent Comprehensive Database Performance Health Check. During the performance tuning exercise, we realized that for one of the table we needed to update the statistics with the full scan as the table was a very critical table for their business. However, every time whenever we were running the update statistics job, the query was running very slow and almost never finish.

Read More

Frequently Asked Questions for SQL Server Performance Tuning Practical Workshop for EVERYONE

Earlier this week I announced my very first online training class open for (US, EU, Asia, and Everywhere) over here: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019, and so far I have received an amazing response. We have sold quite a few seats in the very first few minutes of announcing the class.

Read More

First Online Open for All Class: SQL Server Performance Tuning Practical Workshop for EVERYONE – April 23, 2019

I have been delivering SQL Server Performance Tuning Practical Workshop for various organizations and it has been an extremely popular class so far. I get lots of requesting that I should deliver it for individuals. The only reason, I never scheduled it for individuals was the content of the class was customized carefully for a specific organization. However, I believe it is time now when I can announce this class to everyone.

Read More