TSQL Challenges

TSQL Challenges intend to help you to test and enhance SET based querying skills using TSQL.





Browse by Tags

All Tags » TSQL-Challenge (RSS)
TSQL Challenge 19 – List of submissions received
We have started the evaluation of TSQL Challenge 19 and here is the list of submission we received till 26 Feb 2010. You can find the list of all the solutions at http://databasechallenges.com/sqlserver/tsql/challenge19/submissions . Solutions submitted...
TSQL Challenge #14 - Identify the longest sequence of characters in a string
This challenge is all about identifying sequences of characters in a string using a SET based query. The task is to identify the longest sequence of characters within a given string. Here is the sample data for this challenge Data -------------------...
TSQL Challenge 9 – Solution by Rob Farley
For the TSQL Challenge #9 , Rob was one of the first to provide a very smart and simple solution. Owner/Principal of LobsterPot Solutions, is a SQL MVP and MCT based in Adelaide, Australia where he runs the local SQL Server User Group. He consults and...
TSQL Challenge 9 Winners
Thanks to all That's a repetitive point, but I would like to thank all challengers for their participation. Every solution has its points of interest, and we always spend a lot of time analyzing all the solutions to find the more accurate, different...
TSQL Challenge 8 Winners
Thanks to all Challengers I would like to cheerfully thanks all challengers for their solutions to this challenge. It's the members of a community that grow that community. Information you are sharing here is the very heart of this learning community's...
TSQL Challenge #10 – Horizontal and Vertical Sorting
Wow! Free training to solve TSQL Challenges Along with TSQL Challenge #10, we are introducing a FREE training program to help more people capable of solving real-life TSQL challenges. If you are able to solve a given challenge, please go ahead and send...
TSQL Challenge 7 Winners
First of all, I want to thank all challengers for their contribution. There is more and more people participating, contributing and giving great feedback. All of this, encourage us to continue and help us developing TSQL Challenges community. I hope that...
TSQL Challenge 9
What is new with TSQL Challenges ‘ TSQL Challenges Team’ is working very hard to take this series to the next level. As part of this process, we have redefined the goal and structure of TSQL Challenges. Goal The goal of TSQL Challenges is to help people...
TSQL Challenge 8
Welcome to TSQL Challenge 8! This challenge is more about processing HIERARCHIES. SQL Server 2008 introduced a new data type HIERARCHYID which is pretty good for processing hierarchies. However, the problem explained in this challenge should be fixed...
TSQL Challenge 7
The Context You have done some Sql Server development tasks for a small company that has one Sql Server with several bases. Before you leave, as they will not have any dba to monitor databases, they ask you to write a simple script to help them monitor...
TSQL Challenge 5 - Solution by Friedrich Paul
Friedrich Paul is another many-times-winner of the TSQL Challenges. He uses like Leonid only one CTE with the same split parsing recursively mechanism . This solution is very goods in terms of code optimization (even if it is too much compressed for a...
TSQL Challenge 6
The context For this challenge, you will have to analyse logs on the web server of your company. Here is the sample data you have to work with: ID VisitDate Page NbVisitors --------- -- ----------------------- --------------- ----------- 1 2009-03-23...
TSQL Challenge 4 – Solution by Pinal Dave
Yesterday, we saw the solution for TSQL Challenge 4 by Leonid Koyfman . Another winner of TSQL Challenge 4 is my MVP friend Pinal Dave . Pinal used a very interesting logic in his solution. What I find very interesting with these challenges is that, it...
TSQL Challenge 4 - Solution by Leonid Koyfman
After scanning through the entries whole night, I have identified the best solutions for TSQL Challenge 4 . Since the challenge is to write the shortest TSQL Code, I have identified the entries that produced the correct result and sorted them by the length...