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 – 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.
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.
How to Practise SQL Without a Real Database
You can practise SQL with small invented tables, generated rows, and repeatable exercises without access to a company's production database.
SQL SERVER – Information Related to DATETIME and DATETIME2
A reader comment explains the precision issue between DATETIME and DATETIME2: values lose precision when converted between types. Here is the workaround.







