Connected to many servers in SSMS? HOST_NAME() and SUSER_NAME() show the hostname and current logged in user for any query window.
The Scripts Worth Having on Every Server You Touch
Keep focused DBA scripts for active requests, blocking, table size, index usage, backups, and failed jobs, with clear limits on each result.
SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table
Readers often ask how to check existence of a temp table and how to drop temp table without Msg 2714. My earlier article answers all of these questions.
SQL SERVER – How to Drop Primary Key Constraint
ALTER TABLE … DROP PRIMARY KEY is MySQL syntax and fails in SQL Server with Msg 156. Here is how to drop primary key constraint the SQL Server way.
SQL SERVER – Questions and Answers with Database Administrators
While hiring Database Administrators and senior developers for a large project, we discussed many interesting questions. Here are some, with my own views.






