Dirty pages are pages in memory that SQL Server has changed but not yet written to the data file. This post counts dirty pages and clean pages per database and per object, then watches a CHECKPOINT bring the dirty count to zero. It also explains why you should not try to clean the buffer pool on a production server.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Foreign Key Checks in Insert Plans: The Cost of Each Constraint
Before you drop a foreign key to speed up a load, look at what it costs. This walk-through shows the Assert, the two parent lookups, and the trust trap.
SQL SERVER – Natively Compiled Stored Procedures and Location of Compiler
I recently implemented a Memory Optimized Table solution at one of the large financial organizations while working on Natively Compiled Stored Procedures.
Error 41368: Memory-Optimized Tables and Transactions
Error 41368 appears when an explicit transaction reads a memory-optimized table at the read committed level. This post reproduces the error, fixes it with a table hint or a database option, and shows the two related errors that the fixes do not cure. It also answers what the option changes for other tables.
Enforcing Formats With a REGEXP_LIKE Check Constraint
Stop badly shaped product codes before they reach a report. A short, tested walk-through of anchors, NULLs and adding the rule to old data.
How Much Memory is in Locked Pages? – Interview Question of the Week #228
Question: How Much Memory is in Locked Pages? Answer: Before we see the answer to this question, I suggest you read the blog post here first.
SQL SERVER – Script: Find Last System / Operating System Reboot or Restart Time
Sometimes we need to find last reboot time of the server via some script. In this blog, I am sharing the script to find the last system reboot time.
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.