Posted on November 24th, 2015 by Damodaranaidu Betha
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 […]
Posted on November 24th, 2015 by Ashim Das
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 […]
Posted on November 24th, 2015 by Sneha Chatterjee
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 […]
Posted on November 23rd, 2015 by Arindam Deb
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] […]