One of the biggest issues I see with at various of my customer who signed up at Comprehensive Database Performance Health Check, is about CONVERT_IMPLICIT. As soon as I demonstrate my customer that they are not getting performance due to CONVERT_IMPLICIT their next question is how can they fix the issue of CONVERT_IMPLICIT. In this single blog post, we will learn about how to find this issue and fix it as well.
SQL SERVER – Why Suddenly DBCC CHECKDB Running Very Slow?
Recently during Comprehensive Database Performance Health Check, I was asked a fascinating question. They wanted to know why suddenly their DBCC CHECKDB process started to run very very slow.
Azure – Which One to Get – Standard Disks or Premium Disks
During Comprehensive Database Performance Health Check, I have recently a very interesting experience with an Azure. In this blog post, we will discuss which disks are preferred for performance – Standard Disks or Premium Disks. Well, honestly my answer here is very simple Premium Disks. If you stop reading this blog post over here, I am totally fine as well.
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
While delivering SQL Server Performance Tuning Practical Workshop I recently received a question which is related to performance comparison of Trim and LTRIM/RTRIM.
SQL Server Performance Tuning – Upcoming Public Training
I frequently do various online and offline public training. Once the training gets over, I get a flurry of emails from various individuals that they have missed the last training and would like to sign up for the next training. Here is the list of my upcoming public training. You may sign up anyone you like or all of them!
SQLPASS Pre-Con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs
If you are traveling to SQL PASS, Seattle this year, you do not want to miss out on my pre-con: 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs. This session is going to be amazing fun and very unique. It is full day demo-oriented learning session.
SQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016
In this blog post, we are going to discuss how to fix high CPU Consumption on SQL Server 2016 and SQL Server 2017. One of the large multinational corporations recently hired me for Comprehensive Database Performance Health Check. Usually, customer hires me once and we are able to fix all of their problems in very little time. However, this customer had a very unique scenario and I had to engage twice to help them out.