Refactoring and static code analysis tool for SQL Server
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 30 – Tricky Data

We are about to start the logic testing of TSQL Challenge 30 - A Matrix Transposition challenge in TSQL . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us...

TSQL Challenge 29 – Tricky Data

We are about to start the logic testing of TSQL Challenge 29 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will...

TSQL Challenge 28 – Tricky Data

We are about to start the logic testing of TSQL Challenge 28 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will...

TSQL Challenge 27 – Tricky Data

We are about to start the logic testing of TSQL Challenge 27 . We have created a sandbox for the tricky testing and you can find it here . Please take a look at the tricky data and expected results and let us know if you find anything incorrect. We will...

TSQL Challenge 34 - Search for two keywords within the maximum distance of one word between them

This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them. For example, if 'sql' and 'server' are the keywords, a match will be found on 'Microsoft SQL Server 2008'...

Tricky Data for Challenge 24

For the last four weeks, we have been able to accomplish our goal of completing the evaluation of a challenge every week. The goal for this week is to complete the evaluation of TSQL Challenge 24 . We have crated a sandbox for the tricky testing and you...

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 32 - Clean up phrases by removing noise words

The idea of this challenge is to clean up the phrase from the words identified as 'noise' words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences. ...

TSQL Challenge 20 – Announcing the Winners!

We are just done with the evaluation of TSQL Challenge 20 . The performance testing took much more time than we expected and finally we have the results. You can find the list of winners here . The performance comparison of all the solutions can be found...

TSQL Challenge 19 – Basic Testing Results

We are just done with the basic testing of TSQL Challenge 19. You can see the results at http://databasechallenges.com/SQLServer/TSQL/Challenge19/basic_testing_results We have integrated the email notification feature with the basic testing. The authors...

TSQL Challenge 17 – Winners

I am very glad to announce the winners of TSQL Challenge 17 . There were many solutions that passed the basic testing . However, a major part of them failed the logic testing for a number of different reasons. The data we used for the logic testing is...

TSQL Challenge 21 – List of submissions

The list of submissions we received for TSQL Challenge 21 is posted at http://databasechallenges.com/SQLServer/TSQL/Challenge21/submissions . This includes all the submissions we received till 11th March 2010. If you have submitted a solution and don...

TSQL Challenge 20 – Evaluation Started

We have started the evaluation of TSQL Challenge 20 . The list of submissions we received so far are listed at http://databasechallenges.com/SQLServer/TSQL/challenge20/submissions . So far we received 170 submissions and I think this is one of the challenges...

Claim your SQL Stars!

In my previous post I mentioned that we have setup a new home page for TSQL Challenges. The URL is http://beyondrelational.com/tc.aspx . We have been working on displaying the names of people with most SQL Stars on the page and I am very happy to announce...

Tricky data for TSQL Challenge 18 – English, Swedish and Czech

We are getting ready for the logic testing of TSQL Challenge 18 . The tricky data for the logic testing is published at http://databasechallenges.com/SQLServer/TSQL/Challenge18/logic_testing . We will test the solutions with SQL Server language settings...
More Posts Next page »

Copyright © Beyondrelational.com