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

SQL SERVER – Puzzle – Computed Columns Datatype Explanation

September 27, 2008

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

Yesterday I wrote post about SQL SERVER – Get Answer in Float When Dividing of Two Integer. I received excellent comment from SQL Server MVP Jacob Sebastian. Jacob has clarified the concept which I was trying to convey. He is famous for his “behind the scene insight“. When I read…

SQL SERVER – Simple Puzzle Using Union and Union All – Answer

March 25, 2008

Pinal Dave

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

Database, SQL Joins, SQL Scripts

Yesterday I posted a puzzle SQL SERVER – Simple Puzzle Using Union and Union All, today we will see the answer of this. Following image explains the answer of puzzle. You can read the explanation of why this is answer read my previous article SQL SERVER – Union vs. Union…

SQL SERVER – Simple Puzzle Using Union and Union All

March 24, 2008

Pinal Dave

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

SQL Scripts, SQL Utility

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…