When a long running query makes SQL Server stop responding, sqlcmd with a Dedicated Administrator Connection lets you connect from another computer and kill it.
Granting VIEW SERVER STATE Without Handing Out sysadmin
Grant VIEW SERVER STATE or SQL Server 2022 performance permissions to a monitoring login, add job history access, and test its limits.
SQL SERVER – Find Currently Running Query – T-SQL
A short script to find a currently running query on your server using sys.dm_exec_requests, plus the KILL command to stop one that runs for too long.
SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
Turn on SQLCMD Mode and the SSMS Query Editor can run sqlcmd scripts that mix OS and SQL commands. The interesting part: the OS commands run first.
SQL SERVER – sqlcmd vs osql – Basic Comparison
sqlcmd vs osql: which one should you use to run queries from the command prompt? A short comparison of isql, osql and sqlcmd, and why I pick sqlcmd.
SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor
Change the color of status bar in SSMS 2008 for each server, so a query meant for development never runs on production by mistake. Step by step with images.
SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction
WAITFOR makes a T-SQL batch pause for a set time, or until a clock time, before the next statement runs. I show both uses with small examples.