Introducing new testing levels with complex (tricky) data In the previous post , I had mentioned about the new (improved) evaluation process for the challenges. Brad Schulz is working very hard on leading the process to build the data (which I call ‘tricky...
Better and Stronger Evaluation Process One of the challenges we, The TSQL Challenge Team has, is to come up with a robust evaluation process. As we dig deeper and deeper into it, we realize that it is not as easy as we thought. We need to come up with...
We had a glitch in one of the automatic scripts that we use to evaluate the solutions and had to re-evaluate the solutions last night. After spending the whole night (and unlimited cups of coffee) evaluating and reviewing the different solutions, we have...
Brad Schulz Brad has been working with databases for 30 years. He was a Microsoft Visual FoxPro (VFP) MVP from 1994-2000, and has written articles for various VFP publications. He now devotes most of his time to SQL Server and is a moderator at the MSDN...
Peter Larsson Professional database developer since 2001. Started to use Microsoft SQL Server in 1993, and have been true since then. He mostly working with performance troubleshooting and database architecturing. How did Peter work on the challenge?...
. Hunchback (or Alejandro Mesa) is is a Database developer at Bank of America.He has been working with SQL Server for almost 10 years by now, OLTP and OLAP. Lately he has been more dedicated to dimensional modeling, ETL, OLAP, and reporting services,...
Divya has an original solution based on XML data type methods and PIVOT operator to perform the required sort operation for this challenge. XML Data type is a great feature added in SQL Server 2005. While XML methods can be used to solve...
For this challenge #10, Rob comes with a very nice solution, he was also part of the winners in the TSQL Challenge #9 in July. Owner/Principal of LobsterPot Solutions, is a SQL MVP and MCT based in Adelaide, Australia where he runs the local SQL Server...
For the TSQL Challenge #9, Syed Mehroz Alam is again part of the winners. You can see its previous solutions for the TSQL Challenge #7 and TSQL Challenge #8 . Syed Mehroz Alam, living in Karachi, Pakistan, is primarily a developer focusing Microsoft technologies...
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...
Yesterday, we saw the solution from Syed Mehroz Alam and discovered how Syed used subqueries. Another winner of TSQL Challenge 8 is Leonid Koyfman . First of all, I would like to congratulate Leonid who is a faifthfull challenger and a many times winner...
Yesterday, we saw the solution for TSQL Challenge #8 by Matthieu Hodin . Another winner of TSQL Challenge 8 is Syed Mehroz Alam. First of all, I would like to congratulate Syed. Yes Syed, as you said: it’s a pleasure to learn that the hard work...
For this TSQL Challenge #8 , Matthieu provides us a nice, readable and fast solution. Matthieu Hodin is Project Manager at Wygwam , developper since he got an HP48GX in hands (who remember?), and web developper since 2002. He...
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...
Syed Mehroz Alam prensents us a nice solution using all the principles already described. As obvious, he’s solution is one of the sortests. But let’s present Syed berore running into it: Syed Mehroz Alam , living in Karachi, Pakistan, is primarily...
More Posts