I can confirm Jonathan's performance. My current results: CPU time = 203 ms, elapsed time = 253 ms. Seems like we're using similar solutions... One more issue I think needs to be clarified: Since the requirement says there is no upper limit the test dat

I can confirm Jonathan's performance. My current results: CPU time = 203 ms, elapsed time = 253 ms. Seems like we're using similar solutions... One more issue I think needs to be clarified: Since the requirement says there is no upper limit the test dat

[quote user="dishdy"] @Imu92,#1: I think all testing gets done on SS2K8. If there is an error because maybe you used an SS2K5 feature that's deprecated in SS2K8 then they'll give it a run on SS2K5. I think this includes SS2K features that are still valid

[quote user="dishdy"] @Imu92,#1: I think all testing gets done on SS2K8. If there is an error because maybe you used an SS2K5 feature that's deprecated in SS2K8 then they'll give it a run on SS2K5. I think this includes SS2K features that are still valid

Two questions: #1: will you test the solutions using SS2K5 or SS2K8? The version to be compliant to is either 2K5 and 2K8 (due to the "WITH" requirement), but it makes a big difference whether DATETIMEOFFSET can be used or not... #2: Will an attendee alw

Two questions: #1: will you test the solutions using SS2K5 or SS2K8? The version to be compliant to is either 2K5 and 2K8 (due to the "WITH" requirement), but it makes a big difference whether DATETIMEOFFSET can be used or not... #2: Will an attendee alw

[quote user="theDragon"] A dumb question, can someone please shed some light on this? Note point 8 states “The solution should work on any language setting”, but in the sample script all the tables use varchar rather than nvarchar data type,

[quote user="theDragon"] A dumb question, can someone please shed some light on this? Note point 8 states “The solution should work on any language setting”, but in the sample script all the tables use varchar rather than nvarchar data type,

[quote user="karinloos"] Oh forgot to mention and the totals I now get are ( very very close to urs Dishdy.. i cent off in Feb and 2 cents off on Q total ) - I did change the rounding in my last version to right at the end.. :) but ime still off to your

[quote user="karinloos"] Oh forgot to mention and the totals I now get are ( very very close to urs Dishdy.. i cent off in Feb and 2 cents off on Q total ) - I did change the rounding in my last version to right at the end.. :) but ime still off to your