A nice question. I walked through the problem and got the right answer but the part with the temp table name # concerned me so I had to run it...

I felt that the "Partitions can be on any column" choice was ambiguous too and knew that I had a 50-50 chance of missing it based on that answer alone....

Based on my family history, I most likely would have been in the military (hopefully as some sort of repair man and not as a grunt) or a farmer. If...

I actually grabbed that one from the other post that you and Steve were all over regarding baseball. I sent that link off to most of my programming buddies. Definately...

There is a site out there that has sports databases for baseball, football, basketball and racing.

http://databasesports.com/

also there is a very comprehensive baseball stat database at this site:

http://www.baseball1.com/

Thanks for posting these free training links. However, it would have been nice to see the post a little more in advance since the post was today for training...

Good stuff!

Very nice question. I was unaware of savepoints for transactions either.

Very nice question and great explanation. I could see this coming in handy while troubleshooting someone else's code where they tried to limit their result set but did not know...

I will side with the geeky IT folks and say Spider-Man. I like the fact that is he is a fairly normal guy who has extraordinary powers that he never...

Very nice article. My only comment was to set the end date as one day before the start date of the next row. I believe others have already commented on...

The nice thing about being dedicated to a piece of software or an application is that you become the knowledge expert and eventually work out most of the bugs. The...

I think your formula one car vs house plan analogy is spot on. Sadly, it seems that the only people who get this are the ones doing the development!

It is funny how many people have access to the server rooms when they don't necessarily need it. I've seen knucklheaded PC techs unplug servers and reboot servers without our...

Thanks for the freebie! Happy Friday everyone!