SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek
“Don’t use functions in the WHERE clause, they reduce performance.” I hear this quite often. This is true but this subject is hard to understand in a single statement. Let us see what it means and how to use the function in the WHERE clause. We will be using sample…
Read More
