Reindex every table selectively with SQL Server catalog checks, quoted identifiers, and a clear choice of rebuild or reorganize.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Msg 8152, String or binary data would be truncated, is an error most developers have seen. Here is what causes it and why the setting that hides it needs care.
SQL SERVER – Warning: Null value is Eliminated by an Aggregate or Other SET Operation
Why does SQL Server warn that Null value is eliminated by an aggregate or other SET operation? I show when it appears and how it can be suppressed.
SQL SERVER – The Basics of the Execute Package Task – Notes from the Field #067
SSIS expert Andy Leonard covers the basics of the Execute Package Task, how to configure it and how one SSIS package can call another.
SQL SERVER – Script to Find Leap Year
A simple T-SQL script to check whether a year is a leap year, using DATEADD and EOMONTH to find the last day of February for that year.
SQL SERVER – Error: Fix for Error Msg 3906 – Failed to update database because the database is read-only
Getting Msg 3906, Failed to update database because the database is read-only? The message says it all. Here is how to make the database writable again.
SQL SERVER – Viewing User Configurable Info in SQL Server
A reader asked about sp_user_counter1 to 10 for debugging. I show how sp_trace_generateevent raises events you can watch as User Configurable info.
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.