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

SQL SERVER – Expanding Views – Contest Win Joes 2 Pros Combo (USD 198) – Day 4 of 5

August 9, 2012

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

August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running…

SQL SERVER – Clustered Index and Primary Key – Contest Win Joes 2 Pros Combo (USD 198) – Day 3 of 5

August 8, 2012

Pinal Dave

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

Joes 2 Pros

August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running…

SQL SERVER – Identity Fields – Contest Win Joes 2 Pros Combo (USD 198) – Day 2 of 5

August 7, 2012

Pinal Dave

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

Joes 2 Pros

August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running…

SQL SERVER – Query Hint – Contest Win Joes 2 Pros Combo (USD 198) – Day 1 of 5

August 6, 2012

Pinal Dave

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

Joes 2 Pros

August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running…

SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always

July 9, 2012

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

The amount of email I receive sometime it is impossible for me to answer every email. Nonetheless I try to answer pretty much every email I receive. However, quite often I receive such questions in email that I have no answer to them because either emails are not complete or they…

SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables

June 18, 2012

Pinal Dave

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

SQL Server Management Studio

I love interesting conversations with related to SQL Server. One of my friends Madhivanan always comes up with an interesting point of conversation. Here is one of the conversation between us. I am very confident this blog post will for sure enable you with some new knowledge. Madhi: How do…

SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function

June 16, 2012

Pinal Dave

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

Earlier this week I asked a question where I asked how to Swap Values of the column without using CASE Statement. Read here: A Puzzle – Swap Value of Column Without Case Statement,there were more than 50 solutions proposed in the comment. There were many creative solutions. I have mentioned my personal…