Which query runs faster, one with IN or one with OR? Here is my performance comparison IN vs OR on AdventureWorks, and both turn out equal.
SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?
CONVERT_IMPLICIT warnings are one of the most common performance issues I find in health checks. Here is how to find them in your queries and how to fix them.
The Tipping Point: Why SQL Server Skips Your Nonclustered Index
Find the tipping point where key lookups cost more than a scan, then compare covering and filtered indexes with measured reads.
SQL SERVER – Why Suddenly DBCC CHECKDB Running Very Slow?
Why is DBCC CHECKDB running very slow all of a sudden? A client’s check went from 8 minutes to over 24, so I looked into what changed.
Azure – Which One to Get – Standard Disks or Premium Disks
Many customers get a slower SQL Server after moving to Azure. Should you pick Standard or Premium Disks? My short answer is Premium, and here is why.
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
A workshop question: what is the performance comparison of function TRIM and LTRIM(RTRIM) in SQL Server? Here are the test results.
SQL Server Performance Tuning – Upcoming Public Training
Missed my last class? Here is my upcoming public training on SQL Server Performance Tuning, including Practical Real World Performance Tuning with Brent Ozar.