The job would fail and report at least some of the...

sknox (6/22/2012)

---

Gazareth (6/22/2012)

---

Nice question, thanks.

I'd like to start a quick poll: who's updated the most rows in a live table accidentally by not including a where clause in their update...

If bob is given access via the administrators group and is running the app locally on Win7 then he needs to right click on it and select run as administrator....

You'll want to either add a new operator (right below alerts) or modify the existing operator. Can I recommend putting an email group in so next time this happens...

I'm assuming SQL Agent on Dev2 is what's running the package. Take a look at the error log on Dev1. You'll likely see some login errors for "DOMAIN\Dev2$"...

Try plugging this into your favorite search engine. It's one I've had to look up several times because I didn't use it enough to remember the syntax:

http://www.bing.com/search?q=decode+dtsrun&form=MOZSBR&pc=MOZI&adlt=strict

The following is the crux of the issue:

My first...

Grant Fritchey (6/21/2012)

---

There is a very real, and evidently apparent in more than just the SQL sphere, understanding that you can design for performance on a platform, or you can...

This could actually make RTM releases more solid. With the cloud users working out a number of the bugs we may see less patching necessary on boxes we host.

Good question. I knew it wasn't valid any more but had forgotten that it wouldn't error.

If parallelism is part of the problem you want to decrease the...

Forgot about that. The CTE and row_number won't work either. The list of wait types that he excludes should still vaguely apply but there were undoubtably changes between...

See if this turns anything up. It looks through the default trace for any security events (excluding non-repair checkdbs). You may want to exclude some other things. ...

You should check out Glenn Berry's Diagnostic Queries. The following is pulled from that and provides an easier view of the wait stats:

-- Clear Wait Stats

-- DBCC SQLPERF('sys.dm_os_wait_stats',...

Have you checked for blocking? The issue could be due to concurrency.

Is there anything else running on the server? You could be hitting memory or CPU constraints based...