Bought the Hitchhiker's Guide book back in the mid 80s (saw the BBC telecast way before that); loaned the book to a friend, and never saw it (or her) again...

SSMS for the most part.

I have, and use, Visual Studio for a few things, but find its memory footprint heavy, and the interface is not as responsive sometimes.

And, yes,...

Nice article, Dwain.

I've been using the CTE approach, and hadn't thought about using Cross Apply - but it looks like that's a bit slower anyway. And I'll try to remember...

Yup. I agree.

As a auto mechanic in my former career I had to buy most of my own tools. Some bigger things were supplied by the shop (lifts, Sun machines,...

We installed one - a RegEx string handler to replace unacceptable characters. I want to put another in - a splitter, but there's no pressing need, so it's not on...

"How many snow shovels sold in the US last year?"

Approximately 97% - the rest are stolen. The theft rate is typically low on snow shovels.

Yes, indeed. For over 30 years now I've said (paraphrased) "Losers have excuses,...

Richard,

Thanks for the script - interesting technique.

It looks like line 175 was truncated (@Object needs to be @ObjectId).

Also, on first-run, I'm getting a message:

Warning: The maximum length of the...

I set the context_info at the top of the process, then test the value at the top of the Trigger, and bail if appropriate:

Caveat: I have NOT done this through...

Here's my opinion:

Content width: yes, too narrow; perhaps make it a percentage of the screen width?

Editorial on top: Doesn't matter to me - either way I'll get used to it.

Forum...

Thanks for the step-by-step... I've had a project like this on the horizon for a while (multiple ASII files). Your article helps coalesce a lot of thoughts into a simple,...

I consider my vacation benefit as on par with the other compensation I receive for my time, such as a paycheck. I ask myself (and my boss) if he thinks...

Thanks ALZDBA...

When moving databases I've been using the

EXEC sp_change_users_login @Action='update_one', @UserNamePattern='FQDN\SQLServerUser', @LoginName='FQDN\SQLServerUser';

I never thought of creating the user, at the instance, with the same 'sid'. Brilliant.

ALZDBA (5/11/2011)

---

You...

wow. i wish I had this 11 years ago when I was tasked with a Y to K project - had to change all Y's to K's just before...

Thanks for the article Eli,

I was just the other day trying to remember how to get the resulset back like that. I'd seen an article a while back... maybe it...