Tag Archives: T-SQL

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

Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server

 Monitor CPU utilization, I/O Usage and Memory Usage in Sql Server CPU Usage, I/O Usage and Memory Usage of database   Database level / Database wise CPU, memory and I/O usage As part of DBA’s daily checklist, we need to … Continue reading

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