GilaMonster (5/12/2010)

---

Same way you plan for any other scenario. Examine the risks, the chances of it happening, examine the...

Re-indexed as in recreated the ones that...

That seems to be an awfully low number of allocated pages. Did you run this after hours or during business hours?

Also, did you run it while the queries you...

If you haven't verified what, how do you know it's blocking at all? Are you getting a deadlock error? What messages are you seeing?

Sp_who2 shows blocking SPIDs and you can...

Actually, this other response brings up a good point. What exactly is the proc blocking? Or being blocked by?

It's not a bad idea, but the problem is, you lose all your history going forward from the point of backup.

A slightly better idea would be to export the TABLE...

Ah, I thought it was something specific to the code that you could point me to.

CirquedeSQLeil (5/7/2010)

---

It seems that this statement is causing a lot of page allocations due to the delete statement. I would certainly take it back to the vendor and ask...

Could you share so that future readers of this thread know what to look for?

You're quite welcome.

Depends on how that...

So far as I know, and I could be wrong, you can't Fuzzy Group without a basic Fuzzy Lookup. Which tells me SSIS has a built-in Lookup feature on the...

Is the user there or the login there?

There's a difference. If the login isn't mapped to the database or mapped improperly to the database, then you'll encounter this error.

"Improperly" is...

Please don't take this the wrong way...

Beware the easy out....

This code hits one of my major pet peeves, which probably doesn't contribute much to your problem but certainly doesn't help it either.

Allow me to point out a few...

Elliot is...