In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
Using SQL Server functions in the WHERE clause of your queries can significantly impact performance. Let us explore that in this blog post.
Question: How to Write Efficient Query?
Answer: There is no right or wrong answer to this question. Let us learn about it today.
Earlier this week, I published a video Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140. The video got amazing feedback.
Today we will discuss how a single table scan for multiple aggregated operators helps to improve performance. Let us learn about it today.