I think that very little of SQL is portable these days, Jeff. The basic SELECT code might not be too bad, but I'm sure anything beyond a single statement requires...

I tend to agree with Jasmine. I comment stuff that isn't inherently obvious about why the code is written this way. A business rule, fix a bug, etc. I expect...

It looks like you want a sequence within each set of values. Is this something permanent that you need or is it for reporting? Meaning do you want to add...

OK, first, I didn't work on any 431 books, so don't blame me

Second, you definitely can have multiple snapshots on a database. There...

I think your MCDBA is recognized forever, but as a SQL 2000 certification. SQL 2005 has the MCITPro and MCTS certifications. My guess is they will be updated for SQL...

Can't tell you what the cost is. It's a decision for the people in that situation. Lots of people accept shoddy work in construction, engineering, medicine, etc. for a short...

You are partially right on the opportunity cost. Andy, Brian, and I were all earning hundreds of dollars a month writing when we started this site, at least a car...

Actually there are days the stalls aren't taken care of. There's a tolerance for delays and there are possibly days where food is left out because no one can get...

Jeff,

you bring up great points and I mostly agree.

But the problem for me is that you're talking risk. Most of us have no idea, well not zero, but very, very...

Ha, not sure this site was a risk. It was a hobby that grew and grew and it was fun to put time into. If it had never gotten beyond...

I like the Six Degrees one. We've done the movie guess with 20 questions. Amazing how hard it is to pick a movie no one can guess.

That's very interesting. I'll pass along.

Actually I checked and in the beta of the new site, this works. You get a line from the thread.

There was one on 8/1 and I had some people have filter issues in Exchange. Not sure why, but I got reports of it being snagged in Exchange before it...

Some good advice from Brandie and Jay above.

The key things to get about dealing with management is that they have a different perspective, or a different frame of reference. Neither...

Not sure it's better, but it is easier

Definitely document things. Sometimes there's a reason you're not aware of and sometimes someone is...