In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.
Let us learn today – How I was able to improve the query performance by replacing the cursor with a common table expression (CTE).
Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.
My client during Comprehensive Database Performance Health Check. Today we will learn about CHECK CONSTRAINT to Allow Only Digits in Column.