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.
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.
SQL SERVER – Change Collation of Database Column – T-SQL Script
How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.
SQL SERVER – Connect using Enterprise Manager to SQL Server 2005/2008
Can SQL Server 2000’s Enterprise Manager connect to SQL Server 2005 or 2008? No. You need SQL Server Management Studio, which ships with 2005 and later.