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 – PREEMPTIVE Waits – Simple Definition
Recently a client asked me during  Comprehensive Database Performance Health Check what does it mean to see more preemptive waits on their system.
SQL SERVER – Multiple Optimize Hint for a Query
An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.
SQL SERVER – Scan Count Zero for Statistics IO
On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.
SQL SERVER – Find Oldest Updated Statistics – Outdated Statistics
The word which they had used was Outdated Statistics. Let us learn more about it in today’s blog post. Find Oldest Updated Statistics
SQL SERVER 2019 – Performance Issues After Upgrading from SQL Server 2012
They reached out to me to help them fix their SQL Server Performance issues after upgrading. Comprehensive Database Performance Health Check.
SQL SERVER – Performance Comparison – BETWEEN, IN and Operators
In today’s blog post let us discuss Performance Comparison – BETWEEN, IN, and Operators. I recently discussed this during the Health Check.Â