The answer to my puzzle on Converting Money to DECIMAL(5,2): why it fails with arithmetic overflow, and why DECIMAL(7,2) works, since precision includes scale.
SQL SERVER – 3 Simple Puzzles – Need Your Suggestions
Last month I posted three simple puzzles on the FAST hint, converting money to decimal and RIGHT JOIN. Send your answers and I will publish them with credit.
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 – 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 – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage
My SQL puzzle: which queries create the most TempDB IO and grow its size? Answer with any DMV, and all valid answers get published here with credit.
SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion
I am a quiz master in Jacob Sebastian’s month-long SQL Quiz. My question: if you index a view built on a table, does the table have two clustered indexes?