Author Archives: uday arumilli

SQL Server database backup automation using T-SQL

SQL Server database backup automation using T-SQL I have gone through a request as a part of daily maintenance. Found a backup maintenance plan has been failed due to low disk space.  “SQL Task     Description: Executing the query “BACKUP DATABASE … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , | 1 Comment

How to Delete Duplicate Records in SQL Server

How to Delete Duplicate Records in SQL Server Usually on daily basis we usually need to perform removing duplicate records from a table. This post can help you to understand “How to Delete Duplicate Records in SQL Server”. Here consider … Continue reading

Posted in SQL Development, SQL Scripts | Tagged , , , , , , , , | Leave a comment

How to split a string in sql server

 How to split a string in sql server We have a requirement to capture the list of key words in the given list of statements. In the below example will see How to split a string in sql server There … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , , | Leave a comment