SQLServerCentral: Content tagged SQL Puzzles

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: (not yet rated) |

Discuss |

Briefcase | 40 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 | 30,616 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: TSQL

Rating:

|

Discuss |

Briefcase | 2,843 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 | 3,320 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,248 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,123 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 | 30,616 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 | 52,519 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 | 16,436 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,729 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,184 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 | 1,839 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,086 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,653 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,487 reads

The GO Command and the Semicolon Terminator

There are probably not many SQL Server DBAs that use the semicolon as a statement separator. In SQL Server 2005, this is required in certain places and new author Kenneth Powers brings us a look at where and why you need to use this syntax. Read more...

By Ken Powers 2007/06/15 (first published: 2006/01/09) | Source: SQLServerCentral.com | Category: SQL Puzzles

Rating:

|

Discuss |

Briefcase | 35,412 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 | 16,436 reads

Content with tag SQL Puzzles

Refine your search with one of the following additional tags (with number of items):