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

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

March 20, 2008

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

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…