We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.
Performance: Between and Other Operators – SQL in Sixty Seconds #191
If we use BETWEEN what will be the impact of performance. Let us watch Performance: Between and Other Operators.
SQL SERVER – Change Join Type for Query
“Can I Change Join Type for Query?” I was recently asked this during Comprehensive Database Performance Health Check. Of course Yes!
NOT IN With a NULL in the List Returns No Rows
See why NOT IN with a NULL returns no customers, then compare five sample rows, NOT EXISTS, an IS NOT NULL filter, and query plans.
SQL SERVER – Parallelism and Threads with No Work
One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
SQL SERVER – Top 1 and Index Scan
Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.
SQL SERVER – JOIN Elimination for Not Selected Column
The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.