SQLServerCentral: Content tagged SQL Puzzles

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,920 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,125 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 | 220 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 | 31,998 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,269 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,045 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,782 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,359 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 | 31,998 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,122 reads

Function execution

Delete Duplicates

T-SQL query

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,670 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 | 6,989 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,438 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,241 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,303 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 | 2,940 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,753 reads

Content with tag SQL Puzzles