Performance Testing data for TSQL Challenge 24

The first draft of the performance testing data for TSQL Challenge 24 is available now. You can find the scripts here . Please note that this is under draft mode and we invite your comments and suggestions on the scripts posted.

Announcing winners of TSQL Challenge 23

It is another weekend and we have completed the evaluation of TSQL Challenge 23 . We are very excited that we are able to achieve the goal of ‘completing a challenge every week’ since the last 3 weeks. We aim to complete TSQL Challenge 24 next week and...

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 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...