Before I post summaries, here are my three puzzling questions again: SELECT * vs SELECT COUNT(*), statistics not updating, and functions vs procedures.
SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
SELECT * gives an error when run alone, but SELECT COUNT(*) does not. Why? Here is my SELECT * vs SELECT COUNT(*) puzzle from the Bangalore User Group.
SQL Azure – SQL Azure Throttling and Decoding Reason Codes
The best explanation I have seen of SQL Azure throttling and decoding reason codes, with a graphic. Could a stored procedure decode the reason code for us?
SQL SERVER – Cartoon Challenge – 140 Character Winner is Here
The Idera cartoon challenge drew more than 250 entries. Here is the winning 140 character answer that wins a Windows Phone 7, plus five runners-up.
SQL SERVER – Finding Location of Log File when Primary Datafile is Crashed
Do you need the primary datafile to back up the log after a crash? Vinod Kumar asked, so I tried finding the location of the log file without it.
SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer
My question for SQL Server Quiz 2011: using one table once in a single SELECT, produce an execution plan with a JOIN operator, then one with parallelism.
SQL SERVER – Solution – Challenge – Puzzle – Usage of FAST Hint
The solution to my puzzle on the usage of FAST hint: Brad Schulz shows an AdventureWorks example where the FAST hint really improves performance.