Silverkight Viewer for Reporting Services
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

TSQL Challenge 13 – Solution by Neeraj Mathur and other TSQL Heros

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...
Posted: 11-27-2009 6:37 AM by Jacob Sebastian | with 1 comment(s)
Filed under: , , ,

TSQL Challenge 13 – Solution by Isham Hamin

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...
Posted: 11-26-2009 8:48 PM by Jacob Sebastian | with no comments
Filed under: , , ,

TSQL Challenge 13 – Winning Solution by Jim Carter

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...
Posted: 11-25-2009 6:44 AM by Jacob Sebastian | with no comments
Filed under: , ,

TSQL Challenge 11 - Solution by Brad Schulz

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...
Posted: 10-15-2009 6:08 PM by Rui Carvalho | with no comments
Filed under: , , ,

TSQL Challenge 11 - Solution by Peter Larsson

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?...
Posted: 10-14-2009 11:06 AM by Rui Carvalho | with no comments
Filed under: , , ,

TSQL Challenge 10 – Solution by Alejandro Mesa (Hunchback)

. 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,...
Posted: 09-25-2009 11:40 AM by David Barbarin | with 1 comment(s)
Filed under: , ,

TSQL Challenge 10 – Solution by Divya Agrawal

  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...
Posted: 09-24-2009 9:34 AM by David Barbarin | with 5 comment(s)
Filed under: , ,

TSQL Challenge 10 – Solution by Rob Farley

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...
Posted: 09-23-2009 8:00 AM by David Barbarin | with no comments
Filed under: , ,

TSQL Challenge 9 – Solution by Syed Mehroz Alam

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...
Posted: 07-30-2009 5:22 AM by Rui Carvalho | with no comments
Filed under: , , , , , , ,

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...
Posted: 07-28-2009 10:57 PM by Rui Carvalho | with 2 comment(s)
Filed under: , , ,

TSQL Challenge 8 – Solution by Leonid Koyfman

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...
Posted: 07-04-2009 3:13 PM by Antoine Gémis | with no comments
Filed under: , , , , ,

TSQL Challenge 8 - Solution by Syed Mehroz Alam

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...
Posted: 07-03-2009 4:08 AM by Antoine Gémis | with no comments
Filed under: , , , , ,

TSQL Challenge 8 – Solution By Matthieu Hodin

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...
Posted: 07-02-2009 5:48 AM by Antoine Gémis | with no comments
Filed under: , , , ,

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...
Posted: 06-30-2009 11:54 PM by Antoine Gémis | with no comments
Filed under: , ,

TSQL Challenge 7 - Solution by Syed Mehroz Alam

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...
Posted: 06-25-2009 4:55 PM by Rui Carvalho | with no comments
Filed under: , , , ,
More Posts Next page »

Copyright © Beyondrelational.com