SQL Puzzle Archives - Page 21 of 28 - SQL Authority with Pinal Dave

SQL SERVER – DBA Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

September 12, 2011

SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

My question just got published at DBA Quiz 2011. This question is inspired from a real life incident, which occurred to me a few years ago. That time, I was a DBA myself and then one fine day, everything went south. When we checked the log, all the logs were…

SQLAuthority News – Pluralsight Giving Away Free Subscription to Quiz Participants

August 16, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks, SQLAuthority News

Joes 2 Pros

I am sure readers of this site are familiar with Pluralsight. It is an online training site that describes itself as “a company created by developers, specifically for developers.” At their site you can find training courses on a variety of topics and weekly webcasts by industry specialists. Right now…

SQL SERVER – Two Puzzles – Answer and Win USD 25 Gift Card

June 30, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

Today I have two simple T-SQL Puzzle. You can answer them and win USD 25 Gift card. The gift card will be sent in email to winner. You will get choice of Gift Card brand based on your preference and country location. Puzzle 1: What will be the outcome and…

SQLAuthority News – Monthly list of Puzzles and Solutions on SQLAuthority.com

June 28, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

This month has been very interesting month for SQLAuthority.com we had multiple and various puzzles which everybody participated and lots of interesting conversation which we have shared. Let us start in latest puzzles and continue going down. There are few answers also posted on facebook as well. SQL SERVER –…

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

June 27, 2011

Pinal Dave

SQL Puzzle

SQL NULL, SQL Operator, SQL Scripts, SQL Server

Today is Monday let us start this week with interesting puzzle. Yesterday I had also posted quick question here: SQL SERVER – T-SQL Scripts to Find Maximum between Two Numbers

SQL SERVER – BI Quiz Hint – Performance Tuning Cubes – Hints

June 24, 2011

Pinal Dave

SQL Puzzle

Business Intelligence, SQL Server

I earlier wrote about SQL BI Quiz over here and here.

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

June 21, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Server MVP and my friend Madhivanan has asked very interesting question on his blog regarding How to Generate Zero without using Any Numbers in T-SQL. He has demonstrated various methods how one can generate Zero. When I posted note regarding how one he has generated Zero without using number…