What is the alternative to CASE statement in SQL Server? The IIF function. Here are two examples of CASE and IIF, and why IIF deserves more use.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Automatic Plan Correction: Reading SQL Server’s Tuning Advice
Read automatic plan correction advice, compare regressed and recommended plans, and verify that forcing the last good plan held.
SQL SERVER – Fix Error 3271: A nonrecoverable I/O error occurred on file. The remote server returned an error: (403) Forbidden
A reader’s backup to URL failed with Error 3271: the remote server returned an error: (403) Forbidden. Here is how I reproduced it and the easy fix.
SQL SERVER – What is Forwarded Records and How to Fix Them?
Forwarded Records in heap tables still puzzle many SQL Server users, years after I first wrote about them. Here is what they are and how to fix them.
SQL SERVER – What is Tail-Log Backups?
Tail-Log Backups capture the end of an available transaction log before a restore. I assess them within the intended recovery chain.
Asterisk Instead of a Number: A SQL Server Puzzle
This puzzle assigns a nine digit number to a varchar(8) variable and gets an asterisk instead of a number. The answer is an implicit conversion that does not fit. The post tests which data types behave this way, which ones raise an error, and how to size the variable.
SQL SERVER – Error 1324. The folder path ‘Program Files’ contains an invalid character.
Error 1324. The folder path ‘Program Files’ contains an invalid character. Let us fix the error with the help of the solution in the blog.
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.