COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.
Index Scans – Good or Bad? Lots of people ask about this question and I have built a blog post on the topic – SQL SERVER – Index Scans are Not Always Bad.
Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.