New Born DBA (2/7/2014)

---

Why is it not good practice to use Wizard when creating a maintenance plan? Most DBA's recommends creating it with the script so you have more control...

I've always disliked those types of trick questions, and I've sat often enough on both sides of the table.

"How would you fill a cup of coffee with T-SQL?"

"Get a good...

My pleasure, we've all been there. Glad I could help.

Nope, they're not... not without a lot of workarounds.

You can't control the order that the WHERE clause decides to apply the filters in. You can't even control if a...

:Whistling:

Jeff Moden (2/6/2014)

Heh... I'm used to, welcome, and embrace criticism. It's one of the tools I use to learn new things. For example, if someone could prove to...

I assume you're dumping to a recordset object for the ForEach loop?

Swap the datatype before you include it into the object. (DT_str, 1252) instead of (DT_Date).

The problem is more...

Jeff Moden (2/6/2014)

---

This might better if it was a public "Consensus" rather than what the OP thought. After all, the OP theoretically didn't know squat about the problem to...

Same, looks like it's got a 9 post maximum?

Wherever you go, there you are.

In the above result set, are you using Column B as your 'grouping' control?

The reason I ask is I would...

Then I wouldn't worry too much about it until you get down to brass tacks. In general, though, I would recommend an incremental load just to reduce log usage...

jvanderberg (2/6/2014)

---

I am validating a large database of addresses. I've already deployed a number of ways to validate city, state and zipcode against a lookup database. As a...

Since you're moving to a new system, this would be a good time to doublecheck that you've got some best practices involved in self defense.

In particular, for the concern you...

No worries Newborn.

It's not a bash on doing a maintenance plan, it's a bash on the maintenance plan object. It used to be rather buggy and it doesn't have...