Category: TSQL

I often see various SQL Server DBA & professionals struggling with tempdb. As a DBA it is very common to see issues where some user processes causing tempdb

Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at

As DBA, there are various scenarios where I display duration in results. More often, for visual effects, I like to convert the same duration into [DD hh:mm:ss] format.

As a DBA & instructor, very often I like to generate heavy workload on my SQL Server instances to re-produce scenarios like 100% CPU, zero PLE, high IO,

As a DBA, I often receive user requests to check server slowness. Quite often, slowness is directly linked with active blocking on the server. I find many scripts

When I joined my current organization 2 years back, the biggest problem I faced as DBA was whenever there was Replication, log shipping, Mirroring, or AlwaysOn, the Index

As a DBA/Developer, there have been many occasions where I had to write my own scripts/automation to fulfill specific business requirements. Below are some of those useful scripts

In my organization, we have many SQL Agent jobs that are expected to execute within a particular time window. But there are times when some of them take

Remove High Virtual Log File (VLF) (@OptimizeLogFiles) This generates TSQL code for removing huge virtual log files (VLFs) from SQL Server database log files. By default, @vlfCountThreshold is

It’s very common for Database professionals to experience blocking. Even though blocking is a usual activity, it can convert into an issue anytime. And becomes pain point when