" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Split Delimited String Using XQuery

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 […]

Check Sum Aggregate

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 […]

How To Make A Case Sensitive SQL Query Search

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 […]

How To Reduce The SharePoint_Config_Log File Size

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] […]