Yesterday I blogged about SQL SERVER – Performance Comparison – BETWEEN, IN, and Operators. Following that, I got many emails about the topic.
In today’s blog post let us discuss Performance Comparison – BETWEEN, IN, and Operators. I recently discussed this during the Health Check.
Can a single column and single row result do an entire table scan? I recently got this question in my Comprehensive Database Performance Health Check.
While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
What I love most about my job, is that I get to work with different people and answer questions. Are Not Equal to Operators Equal to Not In?
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.