Viewing 15 posts - 211 through 225 (of 274 total)
Jeff, you can over-engineer, I'll give you that. Huge amounts of wasted I/O to no purpose. But you feel good about it, and obviously for you that's all...
June 15, 2010 at 8:05 am
If you have before and after images of the table(s) in question, there are 3rd party tools, e.g. from RedGate, that can compare them and show you the data differences.
Or,...
June 14, 2010 at 4:17 pm
An interesting quote in a (semi-)recent article from Joe Celko:
Here is a characteristic for good SQL programming: do as much work as you can in ONE statement, so the optimizer...
June 14, 2010 at 3:06 pm
The biggest issue with dynamic SQL (ds) is security. For ds, the executor must have direct permissions to run the DML (/DDL) in the dynamic string; that is, the...
June 14, 2010 at 1:36 pm
how on earth you can show in this table that the student did not take any of tests?
Remember, this is a challenge to get the answerer / [students] to think.
Of...
June 14, 2010 at 10:31 am
You can't go by test#: the middle score might have occurred on any test 🙂 .
This was a request for a specific situation. It's not a design q, was...
June 14, 2010 at 9:44 am
Scott, I can't see how solving such challenges help to learn SQL in deep.
Joe Celko has several (I think) excellent books along these lines.
June 14, 2010 at 9:26 am
Excellent start!
No, sorry for not being more clear, the 'mid score' is the middle score. That is, if the scores are 10, 100, 80, the middle score is 80.
You're...
June 14, 2010 at 9:25 am
Keep novices well away from the Sneaky Tricks Department
This is not a Sneaky technique, just full use of what's available from SQL.
The great part is that this was a...
June 14, 2010 at 8:30 am
Jeff has made two significant points here, that the challenges are unrepresentative of real-world coding and also that they may not be the best means to advance the capabilities of...
June 14, 2010 at 8:09 am
Unless you are hitting a small table, if you are getting scans in your execution plan you should be trying to figure out what you're doing wrong.
That's wrong. It's...
June 14, 2010 at 8:05 am
but I don't see where we are updating the Judges to set isTakingNewCases = 0 after the insert.
No, sorry, it is confusing, but I didn't have time to go into...
June 14, 2010 at 7:51 am
Hmmm... perhaps I should start a new challenge... I'll write some code and we'll have people figure out how the requirements should have been stated
Sigh. Consistently all you want...
June 14, 2010 at 7:39 am
I would think in this situation a single query would be the most efficient. I/O (physical and logical) are the real culprit in performance more than 90% of the...
June 11, 2010 at 4:35 pm
Viewing 15 posts - 211 through 225 (of 274 total)