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

Content with tags T-SQL, SQL Puzzles Rss

   Items 1 to 20 of 44    Older >>
 

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,310 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,120 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,349 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,852 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,120 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,309 reads

Delete Duplicates

By Jamie-2229 2008/05/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,977 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,824 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,470 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,042 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,880 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 | 40,193 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,824 reads

SQLChess - A tutorial on thinking in sets

Chess makes a fantastic game for programming examples. You will find hundreds of examples on the internet. Some dedicated to OO patterns, others to algorithms and so forth. Unfortunately, most of these examples do not use a database or if they do, treat the database as nothing more than a storage repository. In this series of articles we will use SQL Server and T-SQL to implement the game of chess with an emphasis on thinking in sets.  Read more...
By Additional Articles 2007/05/21 | Source: SQLTeam.com | Category: advanced querying
Rating:  Rate this |   Briefcase | 4,535 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

Creating cross tab queries and pivot tables in SQL

For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored procedure will allow you to do it "on the fly". You can add it to your database and start cross tabbing immediately, without any further setup or changes to you SQL code. Check it out, and then take the cross tab challenge.  Read more...
By Additional Articles 2007/04/11 | Source: SimpleTalk | Category: sql puzzles
Rating:  Rate this |   Briefcase | 4,468 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,470 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,309 reads

SQL 2000 DBA Toolkit Part 4

In the final installment of his series, Michael Coles examines a few other functions in his SQL Server 2000 toolkit to help you with other functions, like reading a directory on your server. Read the series and send some feedback to make this THE premier toolset for SQL Server 2000 DBAs.   Read more...
By Michael Coles 2006/05/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,019 reads
   Items 1 to 20 of 44    Older >>
 
Tags
advanced querying (3)    
miscellaneous (3)    
programming (3)    
administration (2)    
ado (1)    
joe celko (1)    
performance tuning (1)    
puzzle (1)    
security (1)    
sql server 7 (1)    
stored procedures (1)    
strategies (1)