TSQL Challenges - Terms and conditions, submission guidelines, Evaluation Process and FAQ

Submission Guidelines

1. Make sure that your solution uses a single query that starts either with "SELECT" or "WITH".
2. Make sure that you create a .sql file with your solution. 
3. The file should be named as 'firstname_lastname_tsqlchallenge_challengenumber.sql". Replace firstname, lastname and challenge number with the actual values. for example, if your name is 'smith jones' and you are trying to solve challenge 101, the file name should be "smith_jones_tsqlchallenge_101.sql".
4. You can submit more than one solutions for a challenge. If you submit more than one solutions for a challenge, add a version number at the end of the file name. For example: "smith_jones_tsqlchallenge_101_v1.sql", "smith_jones_tsqlchallenge_101_v2.sql" etc.
5. Your file should NOT include the sample data provided with the challenge. Provide your single query only (including comments if desired).

Submitting your solution

Do the following to upload your solution.

1. Go to the media gallery 
2. Click on the 'upload' link on the right to of the list view.
3. When prompted to select a media gallary, select "TSQL Challenges"
4. Select your file and click 'Save'

Note: Note that you will not be able to download the solutions. Your submission will be listed publicly, but no other user will be able to download/view your entry until the challenge is closed. Once the evaluation of the challenge is over, we will publish the winning solutions on a different page for public access.

Terms and Conditions

1. By submitting an entry for a challenge, you allow beyondrelational.com to publish it at beyondrelational.com or any of the partner websites
2. We will acknowledge you as the original author when we publish your script/solution.

Evaluation Process

1. The evaluation process starts with verifying that the solutions follow the submission guide lines. Your solution should be a single query that starts with "WITH" or "SELECT". Any solution that use temp tables, cursors, WHILE loops etc will be rejected at this stage.
2. The solutions will then go through a preliminary testing phase which we call "Basic Testing". At this stage, we will test the solutions against the sample data and make sure that they produce the EXACT result as given in the challenge description. If the result does not match 100% with the expected output listing given in the challenge description, the solution will be rejected.
3. Solutions that pass the "Basic Test" will undergo a tougher "Logic Test". During this testing phase, we will test the solutions with some tricky data to check the robustness of the logic used in the solution. Please make sure that your solutions are able to handle exceptional cases, odd and unexpected data etc.
4. Solutions that pass the "Logic Test" will undergo "Load Test" where we will test the solutions against a large number of rows. The number of rows that we use for this testing might vary depending upon the nature of the challenge. During the load testing, the performance data of the solutions will be collected and the winners will be announced based on it.

FAQ

1. I am not able to post a question in the discussion forum of the challenge!
   • You need to be a member of the group 'TSQL Challenges' to be able to post questions or comments in the discussion forum.
2. I am not able to upload my solution - I am getting an error
   • If you are using Google Chrome, try a different browser. The upload functionality does not work with Google Chrome.

Related Posts

Comments