Category Archives: SQL Scripts

Script to Monitor SQL Server Memory Usage

Script to Monitor SQL Server Memory Usage Introduction: This post will takes you through the T-SQL Script to monitor SQL Server Memory Usage. In previous blog post we have explained the parameters involved in understanding sql server memory usage. There … Continue reading

Posted in Interview Q&A, Performance Tuning, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 4 Comments

SQL Script to Monitor CPU Utilization

SQL Script to Monitor CPU Utilization This post helps you in understanding and using SQL Script to Monitor CPU utilization. There are certain scenarios where we can quickly use this script to get SQL Server CPU utilization. When there is … Continue reading

Posted in Performance Tuning, SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 4 Comments

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