In today’s blog post we will discuss one of the most popular questions I receive – Why Do I Never Take Control of Computers Remotely?
SQL SERVER – When You Should Not Attend SQL Server Performance Tuning Practical Workshop for EVERYONE?
So far many of you know that my SQL Server Performance Tuning Practical Workshop for EVERYONE is extremely popular and it is almost full when I am writing this email. I can now accommodate a maximum of 5 individuals in the class as we are reaching capacity. However, yesterday I received a very interesting email which asked me a specific question about the word EVERYONE. Let us read the exact text of the email so you get a clear idea:
SQL SERVER – Default Worker Threads Per Number of CPUs
During my recent SQL Server Performance Tuning Practical Workshop, someone asked, how do they know what is the automatically configured max worker threads.
SQL SERVER – How to Drop All the Hypothetical Indexes of Database?
Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the negative impact of the Database Engine Tuning Advisor (DTA). I was able to help them achieve this by removing the Hypothetical Indexes they had added using the DTA.
SQL SERVER – Query Listing All the Indexes Key Column with Included Column
Today’s blog post is directly inspired by the conversation I had during my Comprehensive Database Performance Health Check. During the consulting engagement, we identified the customers had too many indexes on tables. The goal was to consolidate the indexes and to do the same, we realized that we needed a script which lists all the key columns and included columns of the indexes.
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.
SQL SERVER – Say No To Database Engine Tuning Advisor
I have been using SQL Server for over 20 years and have been working on the focused area of SQL Server Performance Tuning for over 12 years. In recent time I have been very busy doing Comprehensive Database Performance Health Check, and the client, I enjoy working the most is the one who has used in the past Database Engine Tuning Advisor.