you state that nothing was changed in the environment. Have there been any OS patches applied, ANYTHING, even if it doesn't appear to relate to SQL, because my experience...

dbowlin (6/17/2010)

---

I am curious can you please explain the difference between concurrent processing and parallel processing in this context? If you are running processes concurrently, aren't you basically running...

Interesting, I have seen significantly less hardware run 3...

richard.maw (6/17/2010)

---

Interesting stuff but I tried adding "waitfor delay '00:00:01';" to each of the sample work SQL tasks in the OnePackageMethod (before the update statement). That way you can see...

Thanks guys, I hope it helps..

CEWII

Eugene Elutin (6/16/2010)

---

Elliott Whitlow (6/16/2010)

---

...I don't really have any objection if that column is used for comparisons only, if they ever want to display it I might consider smalldatetime... ...

Ed-86789 (6/16/2010)

---

This is something I just learned the other day in another post but haven't had a reason to use yet. You can use .NET Impersonation. It gives...

The answer is yes, there is a lot to it though. One of the bigger issues is breaking up the list into chunks if there are no natural breaks....

I might have misread something earlier but I wasn't thinking they were in the same table, the code presented is unclear. If they are and the difference between then...

I can see how that would work.

It still seems like a lot of operations.

If this is an infrequent or even marginally frequent query it shold probably be ok. If...

You might want to look into sp_xp_cmdshell_proxy_account it is what sets it up. And I am a trust but verify sort of fellow with what I am told by...

You are very welcome. I was struggling to come up with how they could behave different since these are not limitations inherent in the different editions.

CEWII

I agree with the Ninja's suggestion about starting a new thread.

I will however relate one thing that I have seen done and worked pretty well. There was a table...

Before we go to the trouble..

What are you trying to do? What is your end goal?

CEWII

I *partially* agree, it doesn't cause index fragmentation but it is still a HUGE value...