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.
Indexed View Quiz: The Table and Clustered Index Confusion
An indexed view and its base table can each own a clustered index because they are separate objects. Inspect both owners in a SQL example and see why a view index does not give its base table a second clustered index.
SQL SERVER- IF EXISTS(Select null from table) vs IF EXISTS(Select 1 from table)
Is IF EXISTS(Select null from table) faster than IF EXISTS(Select 1 from table)? A great comment thread by Divya, Brian and Marko answers it.
SQL SERVER – Question – How to Convert Hex to Decimal
An inline function converting Hex to Decimal was slowing a client query. I tuned it, and now I ask readers to share the scripts they use for this.
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
sp_spaceused shows the total index size of a table. My puzzle for you: write a query that adds the size of each index to the sys.indexes list.