Most of us have encountered situations like splitting delimited string in a column of a table in SQL SERVER. The very first idea we get is to build a TABLE VALUED function which accepts two parameters, delimited string and delimiter as inputs, and returns a result set which contains the splitted string as rows. The implementation […]

CHECKSUM_AGG: When an update is done on a number column on a table it determines the sum of all the differences of values of the column. This is used mainly to find the difference in the updated values of columns. Suppose there is a column with price list and accidently you change a price. But […]

SELECT COLUMN FROM TABLE WHERE COLUMN=’sql’ But suppose in COLUMN there are data s  like ‘SQL’, ‘Sql’, ‘sQL’ etc so the following query will return all the values which is not desirable. So to make the query case sensitive we should change  the collation(typecast) of the column. SELECT Column FROM Table WHERE Column COLLATE Latin1_General_CS_AS […]

Sometimes, we face some space related issue in SharePoint_Config database. The “SharePoint_Config_Log” file increases rapidly, due to various operations in different SharePoint sites. As a result, it affects the performance of the SharePoint server which is associated with the SharePoint_Config database. The following queries can help us to reduce/shrink the log file size:- USE [master] […]