To drop tables by prefix, list the matching tables first and drop them with a script that quotes every schema and table name. This post shows why the underscore in a prefix is a trap, a one-statement version and a cursor version. It works in SQL Server and in Azure SQL Database.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Performance Condition Alerts: Warnings Before a Log File Fills
Build performance condition alerts for log usage, tempdb free space, and blocking, with sensible delays and an operator response.
TempDB Performance: Five Settings to Check in SQL Server
TempDB performance depends on five settings that you can read in a few minutes: how big it is, how many data files it has, whether they match, how it grows and where it lives. Three read-only queries check each one. The post also explains what to do with the answers.
CHECKPOINT Duration: Can You Speed Up a Manual CHECKPOINT?
The CHECKPOINT duration argument sets a target time in seconds. This post times a manual checkpoint on a database with 130 MB of dirty pages, and shows that a long duration slows it badly while a short one does not make it faster. It also shows that a backup flushes dirty pages by itself.
CHECKPOINT vs DBCC DROPCLEANBUFFERS: Impact on Memory
CHECKPOINT vs DBCC DROPCLEANBUFFERS comes down to which pages leave memory. CHECKPOINT writes dirty pages to disk, and DBCC DROPCLEANBUFFERS removes clean pages from the buffer pool. Here is the effect on memory, with results.
How Dirty or Clean is SQL SERVER’s Memory? – Interview Question of the Week #229
Question: How Dirty or Clean SQL SERVER Database is (by Memory)?
This blog post is the follow up of the earlier blog post on the same subject.
Personal Technology – Bluetooth Volume Problem with Windows Volume Control
Bluetooth volume stays the same from 1 to 100 in Windows? Diagnose Absolute Volume, use a reversible fix, and restore the original setting.
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.