What is in your memory cache? A query on sys.dm_os_buffer_descriptors shows the data pages in buffer pool for each table and index.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Find Largest Supported DML Operation – Question to You
Best practice says the log should be twice the size of the largest supported DML operation. But how do you measure that? Share your ideas with me.
SQL SERVER – Shrinking Database NDF and MDF Files
Previously, I had written a blog post about SQL SERVER. I am posting this blog post here about Shrinking Database.
SQLAuthority News – Author Visit – SQL Server 2008 R2 Launch
I traveled from Ahmedabad to Mumbai for the SQL Server 2008 R2 Launch event on June 11, 2010, with a laser show, PowerPivot demos and great networking.
SQL Server 2025 Editions: What Express and Standard Can Do Now
Compare SQL Server 2025 editions, inspect Express and Standard limits, identify the installed edition, and review database portability.
SQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATE
I repeat my DATETIME and DATETIME2 test with GETDATE instead of SYSDATETIME. See how the distinct values in each column compare this time.
SQL SERVER – Difference Between DATETIME and DATETIME2
A developer filled a DATETIME and a DATETIME2 column with the same value and got different results. Here is the difference between DATETIME and DATETIME2.
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.