One of the biggest issues I see with at various of my customer who signed up at Comprehensive Database Performance Health Check, is about CONVERT_IMPLICIT. As soon as I demonstrate my customer that they are not getting performance due to CONVERT_IMPLICIT their next question is how can they fix the issue of CONVERT_IMPLICIT. In this single blog post, we will learn about how to find this issue and fix it as well.
Question: How to Generate Fibonacci Series for the First 1000 Values?
Question: How to Search Special Characters in Table Column?
While delivering SQL Server Performance Tuning Practical Workshop I recently received a question which is related to performance comparison of Trim and LTRIM/RTRIM.
In this blog post, we will learn about STRING_SPLIT function which was earlier introduced in SQL Server 2016 but still not widely adopted in the industry. We will learn today how to Split Comma Separated Value String in a Column Using STRING_SPLIT.
There are many different datetime related functions such as DAY, MONTH, YEAR, DATEDIFF, etc available in SQL Server. For example, YEAR function can be used to extract year value from a date.