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

Content with tag Puzzle Rss

   Items 1 to 6 of 6   
 

Databases and Dominoes

A Dominoes game of Texas 42 inspires Joe Celko to explore unusual uses for check constraints and views. Sometimes, the best way of discovering useful SQL techniques is to tackle the more unusual problems.  Read more...
By Additional Articles 2013/09/19 | Source: SimpleTalk | Category: puzzle
Rating:  Rate this |   Briefcase | 2,621 reads

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,486 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,336 reads

Monty Hall Paradox

Script to test outcome probabilities of the "Monty Hall Paradox".  Read more...
By Sean Smith 2009/09/09 | Source: SQLServerCentral.com | Category: monty
Rating: |  Discuss |   Briefcase | 1,139 reads

There's a Lot to Learn From Even Simple Puzzles

Phil reflects on the problem-solving power of SQLServerCentral at its best, and mentions some of the impressive contributions to the Summer SQL Stumpers competition  Read more...
By Phil Factor 2009/08/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 375 reads

A Sudoku solution with set based T-SQL utilizing binary operators

A Sudoku solution with set based T-SQL approach utilizing binary values and operators, to ease the algorithm.  Read more...
By Kevin Duan 2011/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,486 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (2)    
advanced querying (1)    
editorial (1)    
fun (1)    
games (1)    
hall (1)    
miscellaneous (1)    
monty (1)    
paradox (1)    
probability (1)    
sql puzzles (1)    
sql server 2005 (1)    
sqlservercentral (1)