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

SQL SERVER – Relationship with Parallelism with Locks and Query Wait – Question for You

June 25, 2013

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

Today, I have one very simple question based on following image. A full disclaimer is that I have no idea why it is like that. I tried to reach out to few of my friends who know a lot about SQL Server but no one has any answer. Here is…

SQL – Contest to Get The Date – Win USD 50 Amazon Gift Cards and Cool Gift

June 20, 2013

Pinal Dave

Big Data, SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

NuoDB

If you are a regular reader of this blog – you will find no issue at all in resolving this puzzle. This contest is based on my experience with NuoDB. If you are not familiar with NuoDB, here are few pointers for you. Step by Step Guide to Download and…

SQL SERVER – Puzzle #1 – Querying Pattern Ranges and Wild Cards

June 11, 2013

Pinal Dave

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

Joes 2 Pros

Note: Read at the end of the blog post how you can get five Joes 2 Pros Book #1 and a surprise gift. I have been blogging for almost 7 years and every other day I receive questions about Querying Pattern Ranges. The most common way to solve the problem…

SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL

May 28, 2013

Pinal Dave

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

SQL Scripts

Earlier I have posted a puzzle which received so many valid responses and got a fantastic explanation to the questions as well. I encourage all of you to read the original puzzle here. First run following script: SET ANSI_NULLS ON; -- Query1 SELECT 'SQLAuthority' AS Statement11 WHERE 'Authority' IN ('S','Q',…

SQL SERVER – Solution to Puzzle – REPLICATE over 8000 Characters

May 17, 2013

Pinal Dave

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

SQL Function

Earlier this week, I asked a puzzle about how REPLICATE works with 8000 and over 8000 characters. I strongly suggest to read the original blog post where I have described the problem in detail SQL SERVER Puzzle – REPLICATE over 8000 Characters. Just quick to summarize the puzzle. Here is the quick…

SQL SERVER – SQL Puzzle of SET ANSI_NULL – Win USD 50 worth Amazon Gift Cards and Bubble Copter R/C

May 15, 2013

Pinal Dave

SQL Puzzle

SQL Scripts

Note: This contest is over, so enjoy the brain teaser about ANSI_NULL. We all love puzzles and here is interesting puzzle which you can play with me and win Amazon Gift Cards and Bubble Copter R/C. The contest for Amazon Gift Card is open worldwide, however, Bubble Copter winner will be chosen from USA only.

SQL SERVER – How to use xp_sscanf in Real World Scenario?

May 14, 2013

Pinal Dave

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

SQL Scripts

I need your help. I recently came across extended stored procedure xp_sscanf. After reading a lot about it and searching online, I could not figure out how and where in real world, I will use this function. Microsoft documentations suggest that this extended stored procedure reads data from the string…