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

SQL SERVER – Simple Puzzle Using Union and Union All

March 24, 2008

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

I often get request to write puzzles using SQL Server. Today, I am presenting one very simple but very interesting puzzle. What will be the output of following two SQL Scripts. First try to answer without running this two script in Query Editor. Script 1 SELECT 1 UNION ALL (SELECT…

SQLAuthority News – Book Review – Joe Celkos SQL Puzzles and Answers, Second Edition, Second Edition

March 20, 2008

Pinal Dave

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

Database, SQLAuthority Book Review

Joe Celko’s SQL Puzzles and Answers, Second Edition, Second Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback) by Joe Celko (Author) Link to Amazon Short Review: This book is for all of them who enjoy little puzzles or just something which gives them challenge. Some puzzles took hours…

SQL SERVER – sp_HelpText for sp_HelpText – Puzzle

June 15, 2007

Pinal Dave

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

SQL Scripts, SQL Stored Procedure

It was interesting to me. I was using sp_HelpText to see the text of the stored procedure. Stored Procedure were different so I had copied sp_HelpText on my clipboard and was pasting it in Query Editor of Management Studio. In rush I typed twice sp_HelpText and hit F5. Result was…

SQL SERVER – Union vs. Union All – Which is better for performance?

March 10, 2007

Pinal Dave

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

SQL Download, SQL Scripts

This article is completely re-written with better example SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison. I suggest all of my readers to go here for update article. UNION The UNION command is used to select related information from two tables, much like the JOIN…