To change a column from INT to BIGINT, you first drop every key and index that depends on it, because ALTER COLUMN refuses with Msg 5074 and Msg 4922. This post builds a small ticket system, shows the errors, and changes the key and its foreign key inside one transaction. It also shows how a negative identity reseed buys time, and when to copy the table instead.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Could Not Load File or Assembly ‘SqlManagerUi, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or One of its Dependencies
SSMS database properties failed with “Could not load file or assembly SqlManagerUi” for my client. Here is what caused the error and how we fixed it.
How Default Value and Nullable Column Works? – Interview Question of the Week #129
How do a default value and a Nullable Column work together in one table? Two short scripts from an interview panel show exactly what SQL Server does.
MSDB Growth From queue_messages: How to Clear the Queue
MSDB growth from the queue_messages tables means a Service Broker queue holds messages that nobody reads. This post builds a queue with unread messages in a test database, finds it with a size query, ends only its conversations with the CLEANUP option, and watches the space come back. It also says why you should never end every conversation in msdb.
Log Shipping Alternative for Databases in Simple Recovery Model
A log shipping alternative for a database in the simple recovery model is a second copy that restores the newest full backup and the newest differential backup. This post finds those two files from the backup history in msdb, restores them with MOVE and RECOVERY, and repeats the cycle on a schedule. It also states what you lose compared with real log shipping.
SQL Server – How to Get Column Names From a Specific Table?
I get column names from schema-qualified table metadata. Catalog views help when I also need SQL Server-specific details.
SQL SERVER – Puzzle – Incorrect Results with Decimal
A new puzzle: a simple table with price and discount returns Incorrect Results with DECIMAL. Can you work out why without running the code in SSMS?
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.