Geoff - that is awesome!! Very nice presentation - and it covers all the prime touch points near and dear to the DBA at a glance. My curiosity...

Geoff - nice article, thanks for posting.

One thing I wanted to mention on security, if the account that SQL Agent runs with is denied access to run a command line...

Steve - you and I are cut from the same cloth, my friend. I've been allowing a lot of those same thoughts to creep through my approaching-50 year-old brain...

Steve -

I know this thread will get a lot of mileage, but my goodness I hope you read my post here:

YOU ARE ABSOLUTELY IN THE RIGHT TO WRITE THAT...

Hi guys, I realize I'm late to join the fray, but ye gads what a lively topic! I just saw the link posted in my morning newsletter from SQLServerCentral.com...

arbarnhart - you hit the nail on the head. When you say, "...but I often choose which way to do something based on how long it will take to...

Wow, I could expound for hours on this one. And what excellent fodder for a forum of experienced DBA's who have "been there - done that". There have...

Bill - excellent editorial, and I like your thinking. I think that too many of us in the IT world become possesive with our knowledge and skills, and forget...

Well, this is why I don't post a whole lot, I sometimes type without thinking! You CANNOT execute any DDL for the table var outside of its declaration, therefore...

There have already been a couple replies on this so I won't belabor too much, but you definitely can create a PK on a table variable, you just can't name...