In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
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.
How to Write Efficient Query? – Interview Question of the Week #300
Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.
SQL SERVER – Follow Up Question on Write Efficient Query
Earlier this week, I published a video Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140. The video got amazing feedback.
SQL SERVER – Single Table Scan for Multiple Aggregated Operators
Today we will discuss how a single table scan for multiple aggregated operators helps to improve performance. Let us learn about it today.