Category Archives: T-SQL

Running processes including job step name

The normal output of sys.dm_exec_sessions (or sysprocesses) will tell you that a job is running, but it will hide the name of the job behind a heximal representation of the job_id, not the job_id as displayed in sysjobs. This script … Continue reading

Posted in T-SQL | 2 Comments

Slow delete with immediate output

Posted in T-SQL | Leave a comment

The curious case of the trailing space

Some weeks ago, a developer told me he had found some strange behavior in SQL Server. Someone immediatelly yelled “bug”. Comments like this always grab my attention. More often than not, however, it’s not a bug. That also turned out … Continue reading

Posted in T-SQL | Leave a comment