A puzzle for you: why does converting money to decimal throw Msg 8115, an arithmetic overflow error, when you cast 12345.67 as DECIMAL(5,2)? Share your answer.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Challenge – Puzzle – Usage of FAST Hint
When does the FAST hint help? It asks SQL Server to return the first rows quickly, yet my tests showed no change in time. Can you find a good example?
SQL SERVER – Concat Function in SQL Server – SQL Concatenation
Is there a CONCAT function in SQL Server? An attendee said MySQL and Oracle have one. I show how the plus operator joins strings, numbers and column values.
geometry STIsEmpty: Empty Shapes Are Different From SQL NULL
geometry STIsEmpty tests whether an existing spatial instance has an empty point set. I keep that condition separate from SQL NULL. A missing database value and a present empty geometry are different inputs.
SQLAuthority News – SQLPASS Nov 8-11, 2010-Seattle – An Alternative Look at Experience
SQLPASS 2010 in Seattle was the best summit ever. Instead of the usual event report, here is an alternative look at my trip, travel stats and fun moments.
LIKE Cardinality: String Statistics and Row Estimates
LIKE row estimates depend on the pattern, string statistics and compilation context. Compare estimated and actual matching rows in a controlled distribution, while keeping cardinality estimates separate from the chosen access path.
SQL SERVER – Change Database Access to Single User Mode Using SSMS
I showed before how to set single user mode with T-SQL before a backup. You can also set single user mode using SSMS, from the database properties page.
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.