Lots of people had no idea that even index can also reduce the performance of SELECT queries. In this blog, we discuss 3 follow up questions.
Recorded Class : Buy One Get One – SQL Server Performance Tuning Practical Workshop for EVERYONE
This is a buy one get one to my recorded class SQL Server Performance Tuning Practical Workshop for EVERYONE. Very unique offer for everyone!
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was using SQL Server 2019 for their environment and they wanted me to help them with the new feature of Accelerated Database Recovery.
SQL SERVER – How Do I Evaluate Monitoring Tools?
Today, I am going to talk about the 3 important properties which I look for in all the SQL Server Performance monitoring tools.
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
Lots of people often ask me as I share pretty everything on the blog – Do I have any Business Secrets. Actually, the answer is no, I never keep any secrets. I always share everything I know and I want my customers and readers learn along with me. Today I will share another script which I have written which I frequently use with my consulting engagement Comprehensive Database Performance Health Check.
SQL SERVER 2008 R2 – I Support You Beyond July 9 2019
One of my clients is primarily using SQL Server 2008 R2 for most of their application. SQL SERVER 2008 R2 – I Support You Beyond July 9 2019
SQL SERVER – Performance Monitoring Week – Wrap Up
I absolutely love my job using Comprehensive Database Performance Health Check, which has inspired me to write Performance Monitoring Week.