Should be careful when shrinking your database on LIVE environment

Today, I would like to tell you the pain story that I have encountered on LIVE environment. A couple of days ago, I received a request from my client. They needed to restore a database and then run some updates on the database. The database contained data of 8 years from 2009 to 2016. However, they … Continue reading Should be careful when shrinking your database on LIVE environment

How to work with STRING_SPLIT in SQL SERVER 2016

PROBLEM When you work on SQL Server Editions that are prior to SQL Server 2016, it is very difficult for us to split a string with a specified separator such as comma,... You must build your own table-value function to split the string. SOLUTION However, we have a built-in function that named STRING_SPLIT function which is one … Continue reading How to work with STRING_SPLIT in SQL SERVER 2016