This month has been an exciting month for SQLAuthority.com, with multiple puzzles and interesting conversations shared among our readers. Let’s dive into the latest puzzles and discussions:

Puzzle Involving NULL – Resolve – Error – Operand data type void type is invalid for sum operator

In this puzzle, we encounter an error involving NULL values. The challenge is to resolve the error, and our readers have contributed various methods to tackle this issue. It’s important to note that NULL values can significantly impact the results of a query, leading to unexpected outcomes.

T-SQL Scripts to Find Maximum between Two Numbers

While exploring scripts to find the greatest number between two given numbers, we stumbled upon a small bug in a script provided by a friend. However, our readers have suggested better scripts, and Madhivanan has even written a blog post on this topic. You can find his post on our website.

BI Quiz Hint – Performance Tuning Cubes

Our friend Jacob is hosting a quiz on his site, and we have provided several hints on how to tune cubes for better performance. Participate in the quiz for a chance to win exciting prizes!

Solution – Generating Zero Without using Any Numbers in T-SQL

Madhivanan posed an interesting question on his blog about generating zero without using any numbers in T-SQL. He demonstrated various methods to achieve this, and we received many interesting answers from our readers, which we have shared on our blog.

Solution – Puzzle – Statistics are not Updated but are Created Once

This puzzle challenged our readers to identify why the statistics of certain tables were not getting updated, despite correct settings. Solving this puzzle required knowledge of indexes, statistics, and database settings. We received multiple solutions, and it was fascinating to see the different approaches taken by our readers.

Question to You – When to use Function and When to use Stored Procedure

In this straightforward question, we asked our readers to share their insights on when to use a function versus a stored procedure. We received great answers, but there is still room for more detailed explanations. Feel free to join the discussion and share your thoughts.

Selecting Domain from Email Address

We explored the topic of selecting domains from email addresses. Madhivanan turned this into a puzzle and wrote a follow-up post on various ways to find email addresses from a list of domains. Check out his post on our website.

Guest Post – Job Interviewing the Right Way (and for the Right Reasons)

We are thrilled to feature an amazing guest post by Feodor Georgiev, who wrote about job interviewing the right way and for the right reasons. This article is a must-read for everyone.

Stay tuned for more exciting puzzles, discussions, and informative articles on SQL Server concepts and ideas. Don’t forget to follow us on social media for the latest updates!