Kevin's solution works for me. I was stuck thinking about CUBE or ROLLUP or something else to avoid a cursor. Updates on a temp table didn't occur to me.

Thanks!

Was the 70-431 actually hard, or the whole SQL2K5 certification process? I'm a SQL2K MCDBA, so I took 70-431 and thought it was pretty easy. Most of the stuff was...

Never mind, It looks like I fixed it. It makes no sense, but at least it works.

I had an Active X scritp to copy the Access database from a...

I'm guessing The Bourne Identity 🙂

Ian put it very well above. I too am distracted by the tone of the articles at times. The technical content seems good.

It sounds like a depressing place to work, but I'd be interested to hear the other side of the story.

The article heading mentioned "DBA Janet Wong brings us one of...

 "I opened a DTS package; it transferred five tables from one database of one server to another database of another server. Well, how many connections would you create? Two right?...

There's a site for coders, http://coderific.com/.

Is there suposed to be a link to the article that Steve is referring to in the editorial? I don't see any. Sounds like an interesting article.

The answer says True, but the explanation says false... it's confusing unless this is a typo...

Embarcadero ER/Studio for data modeling. Great tool, easier to use than ERWin.

If you have a two node Windows cluster, here's the breakdown:

1) One SQL Server Virtual Server installed - Active/Passive.

2) Two SQL Server Virtual Servers installed - Active/Active

This is kind of...

I didn't realize that there was any illegal data mining going on in this case. I thought it was the pretexting (basically impersonating) that was against CA law.

I suppose...

You can also right click the DTS package itself and choose Schedule Package - no need to open the DTS package.

It's in Enterprise Manager under Data Transformation Services, Local...

I don't think there's a good rule of thumb for this. With database sizes ranging up to terrabytes, there's no way RAM can be made to match. I've managed everything from...