We explore an alternative approach when dealing with high volumes of ‘OR’ conditions in our SQL queries: the use of a TempTable.
SQL SERVER – A Comparison of CHARINDEX vs LIKE
In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
Oversized varchar Columns and Inflated Memory Grants
Investigate oversized varchar declarations, compare sort memory grants, and narrow string columns safely without losing valid data.
SQL SERVER – Avoid Functions in the WHERE Clause for Performance
Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
Running Distinct Counts: Working Around COUNT(DISTINCT) OVER
Your report wants unique customers so far, and SQL Server refuses COUNT(DISTINCT) over a window. Flag each first appearance and add up the flags instead.
SQL Server Deadlocks – Interview Q and A
Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers
50 Minutes vs. 4 Hours for Database Performance Health Check
the On-Demand (50 Minutes) consultation and the Comprehensive Database Performance Health Check (4 Hours).