Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Puzzles Rss

   Items 1 to 20 of 52    Older >>
 

Celko's SQL Stumper: Eggs in one Basket

Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.   Read more...
By Additional Articles 2010/04/05 | Source: SimpleTalk | Category: sql puzzles
Rating:  Rate this |   Briefcase | 1,985 reads

The SQL of Scrabble and Rapping

In which Phil decides to use a table consisting of all the common words in English to explore ways of cheating at Scrabble and writing doggerel using SQL Server. He then issues a SQL challenge.  Read more...
By Additional Articles 2009/12/30 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 2,279 reads

Speed Phreaks

A guest editorial from Phil Factor looks at the Speed Phreak competition that has been taking place recently and is quite popular. Read about the inspiration for the competition and why you might want to participate.  Read more...
By Phil Factor 2009/11/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 230 reads

Just For Fun: An Impossible Delete

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...
By RBarry Young 2009/10/30 (first published: 2008/08/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 32,099 reads

Celko's SQL Stumper: The Data Warehouse Problem

Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!   Read more...
By Joe Celko 2009/09/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,338 reads

TSQL Challenge #12 - Build sequential ranges of dates with propagation to missing values

Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.  Read more...
By Press Release 2009/08/18 | Source: Other | Category: sql puzzles
Rating: (not yet rated)  Rate this |   Briefcase | 4,112 reads

Celko's Summer SQL Stumpers: Prime numbers

Our first Stumper sees Joe Celko providing a conundrum with a prize for anyone who can come up with a better solution than he can.  Read more...
By Joe Celko 2009/07/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,842 reads

The Bejeweled Puzzle in SQL

Alex Kozak provides another SQL puzzle to hone your SQL Skills with.  Read more...
By Additional Articles 2008/10/17 | Source: SimpleTalk | Category: sql puzzles
Rating:  Rate this |   Briefcase | 4,428 reads

Just For Fun: An Impossible Delete

How can you delete only some duplicates? Without Identity's, Temp tables, Cursors, loops or ROW_NUMBER()? Would you believe, go back to the 70's?  Read more...
By RBarry Young 2009/10/30 (first published: 2008/08/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 32,099 reads

Eliminating Cursors

T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.   Read more...
By Kamran Ali 2008/06/13 (first published: 2006/01/17) | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 54,289 reads

Function execution

Rating: (not yet rated) |  Discuss |   Briefcase | 4,177 reads

Delete Duplicates

By Jamie Longstreet-481950 2008/05/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,968 reads

T-SQL query

By Raghavan CV 2008/05/02 | Category: sql puzzles
Rating: (not yet rated) |  Discuss |   Briefcase | 4,671 reads

The T-SQL Quiz

Longtime SQL Server DBA and author Grant Fritchey decided to quiz his developers on how to perform some simple functions in T-SQL. Read about his results and see how you might do in taking his quiz.   Read more...
By Grant Fritchey 2007/05/28 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 17,793 reads

Full Control Over a Randomly Generated Password

All of us need a steady stream of random passwords for the various systems we manage. Peter Larsson brings us an interesting T-SQL solution that generates one for us.   Read more...
By Peter Larsson 2007/04/25 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 7,009 reads

Finding Primes

While it's not likely that many of you need to find prime numbers using T-SQL, it is an interesting programming exercise. SQL Server guru Kathi Kellenburger brings us one solution after taking a break over the holidays and reading some popular fiction.   Read more...
By Kathi Kellenberger 2007/01/29 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 6,468 reads

SQL Puzzle 8

A new puzzle that asks about implementing a powersum function.  Read more...
By Additional Articles 2007/12/06 | Source: SimpleTalk | Category: sql puzzles
Rating:  Rate this |   Briefcase | 2,304 reads

SQL Puzzle 7

After a gap of sixteen months, Lionel Clarke, the creator of the only 3-D maze game to be written in TSQL, returns with a new SQL puzzle. It is very simple. You have to move as much of the data as you can from the source tables to the destination tables.   Read more...
By Additional Articles 2007/11/08 | Source: SimpleTalk | Category: sql puzzles
Rating: (not yet rated)  Rate this |   Briefcase | 2,371 reads

Celko's 'Can't Be Your Own Supervisor' SQL Puzzle

A SQL puzzle from the SQL guru.  Read more...
By Additional Articles 2007/09/14 | Source: Intelligent Enterprise | Category: sql puzzles
Rating:  Rate this |   Briefcase | 3,029 reads

A Raffle Puzzle

An interesting puzzle from the Orlando SQL Server Users Group  Read more...
By Additional Articles 2007/08/13 | Source: End to End Training | Category: sql puzzles
Rating:  Rate this |   Briefcase | 1,860 reads
   Items 1 to 20 of 52    Older >>
 
Tags
t-sql (36)    
advanced querying (3)    
miscellaneous (3)    
programming (3)    
administration (2)    
ado (1)    
editorial (1)    
joe celko (1)    
performance tuning (1)    
puzzle (1)    
security (1)    
sql server 7 (1)    
stored procedures (1)    
strategies (1)    
t-sql challenges (1)    
user defined function (udf) (1)