Use CROSS APPLY and VALUES for unpivoting columns, retain nulls deliberately, preserve labels, and turn paired fields into aligned rows.
WITHOUT_ARRAY_WRAPPER: Keep JSON Cardinality Explicit
WITHOUT_ARRAY_WRAPPER needs a single-row JSON contract. Compare one object with two unwrapped objects and validate the complete generated text.
SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists
If LEFT JOIN does the same work, the puzzle is why RIGHT JOIN exists at all. Can you show a case where it is truly required? Share your answer.
SQL SERVER – Puzzle – Challenge – Error While Converting Money to Decimal
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.