Its a topic I covered a couple weeks back while studying for the exam. It made my day to get it right.

Thanks.

Great article!

Really good info from Jim Cheong too!

I know I'll be upgrading some old Excel work sooner rather than later, and the current lack of a 64 bit Jet driver...

A really good QotD! Thanks.

Any recommendations for training"

I've been using the 70-432 Self Paced Training Kit, MS Press Implementation and Maintenance, and found that Reagan's Trust but Verify adage holds true for it, so...

Of course it's different for any given circumstance. But regardless, I like to think that - say Monday is a holiday. When Tuesday morning comes, I would like to be...

Oh how well I recall the price for not archiving...:rolleyes:

Excellent article!

Hey! That's just good stuff.

Thanks for a well written article.

Yeah. What he said. Full means complete, all in one.

Nice question.

paul.goldstraw (2/1/2010)

---

....

Nothing wrong with any of that, but for those who don't know the answer, should they be running the code before they answer, or after they have answered and...

It's a good QOD because it served it's purpose of educating some, and now everyone has their points. For those who haven't checked out @@ROWCOUNT in BOL, please do so.

Note...

@@ROWCOUNT always returns the number of rows affected by the most recent command on the current connection.

Some commands might surprise you. The following returns 1, 1.

declare @ChangeRowCount bit

set @ChangeRowCount =...

That's really cool to know.

Thanks for a good QOD.

I mentioned using a company abbreviation prefix as a...

I typically have never seen the need for prefixing the object names in any database that I developed with the exception of some field names, and I come from a...

WayneS (1/24/2010)

---

.................

Edit: I also curious... how much are cascading updates/deletes used in a production environment? Personally, I've never seen it actually used, so I'm curious as to how much it...