A registry query lists SQL Server Instances recorded on the Windows host. A customer wanted a T-SQL-only method.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Drop Multiple Tables with One DROP TABLE Statement
To drop multiple tables in SQL Server, list them in one DROP TABLE statement, referencing tables first. This post tests the order rule on a parent and child table and shows what happens after an error. It also covers IF EXISTS, drops by name pattern and temporary tables.
SQL SERVER – DBCC CHECKDB Waiting for PREEMPTIVE_OS_DEVICEIOCONTROL
A weekly DBCC CHECKDB job was stopped by a terminator job, but its SPID stayed, waiting on PREEMPTIVE_OS_DEVICEIOCONTROL. Here are ways to handle that situation.
Do Index Reorganization Update Statistics? – Interview Question of the Week #196
Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
Full-Text Index Blocking Redo on an Always On Secondary
A full-text index can block the redo thread of a readable Always On secondary. This post shows the three clues to read in sys.dm_exec_requests, how to find the internal table and how to check change tracking. It ends with the fix: manual tracking and a scheduled population.
DBCC PAGE Alternative: Read Page Headers with T-SQL
The best DBCC PAGE alternative is the function sys.dm_db_page_info. This post builds a demo table, lists all of its pages with the allocation view, and compares one page with DBCC PAGE. It also explains the two modes and the page wait use.
SQL SERVER – Unable to Create Always On Listener – Attempt to Locate a Writeable Domain Controller (in Domain Unspecified Domain) Failed
Can’t create an Always On listener? On three clusters, Event ID 1212 said the attempt to locate a writeable domain controller failed. I walk you through the fix.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.