Recently while working with my client I ended up in a very interesting situation where my client wanted me to write an Efficient Query.
Do you know what a single arrow means in an execution plan? While we popularly call it the arrow, there is a technical name for these little arrows.
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.