Question: How to Search Special Characters in Table Column?
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
While delivering SQL Server Performance Tuning Practical Workshop I recently received a question which is related to performance comparison of Trim and LTRIM/RTRIM.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
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.
SQL SERVER – Fix Error: Invalid object name STRING_SPLIT
Just the other day one of the readers sent me following email after reading my earlier blog post: STRING_SPLIT Function Performance Comparison. He really liked the new feature of SQL Server 2016 and decided to start using this new feature. However, as soon as he started to use this feature, he received following error. He was very much confused why he was not able to use the STRING_SPLIT function even though he had SQL Server 2016.
SQL SERVER – How to Get SQL Server Agent Properties?
During Comprehensive Database Performance Health Check we always go over various SQL Server properties. Lots of people do not know that there are quite a few SQL Server settings which can help us improve our SQL Server performance many folds. While I was discussing SQL Server properties, someone asked me if there are similar settings for SQL Server Agent available which users can tune.
SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960
SQL installation and parching are the processes which every DBA has to do. Some smart DBAs do this via script and some go with a manual approach. When it fails, it is fun to debug it because you have to take help from internet to find possible causes and solution. In this blog, we would learn about how to fix error Unable to open Windows Installer file -2147286960.
How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171
Question: How to List All the SQL Server Jobs When Agent is Disabled?