Browse by Tags
All Tags »
TSQL-Challenge (
RSS)
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...
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 -------------------...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...