You might be able to figure out what is happening by using wait stats. I'd start with this post[/url] by Brent Ozar.

Stefan Krzywicki (9/2/2011)

---

GSquared (9/2/2011)

---

GilaMonster (9/2/2011)

---

GSquared (9/2/2011)

---

So, I've probably had wildlife closer than Gail has, despite the fact that she lives in a grass hut and hasn't ever even heard of...

jcrawf02 (9/2/2011)

---

Jack Corbett (9/2/2011)

---

Steve Jones - SSC Editor (9/2/2011)

---

As we were getting the kids ready this am, a family of deer (buck, doe, 2 kids) walked through the front yard....

If I understand you correctly the Child Package should be using the same value as the parent package. My understanding is that the master package has the variable conn_ReaFilePath...

AS Gail and Lowell have mentioned the indexes are different, but they could be redundant depending on the queries sent to the database. I'd suggest checking sys.dm_db_index_usage_stats to see...

Steve Jones - SSC Editor (9/2/2011)

---

As we were getting the kids ready this am, a family of deer (buck, doe, 2 kids) walked through the front yard. The girls were...

Good article with simple concise explanations. I actually don't remember knowing that the Simple recovery model had minimally logged operations. I thought the logging was the same as...

I do park in one of two spots at my current office. I picked them because they were empty the first time I came in. There is nothing...

Marios Philippopoulos (8/31/2011)

---

I get it for something called...

Posted this on Twitter and got an interesting question. Are you seeing this happen with a specific application like Access?

Looking over the thread again I notice you installed and then applied SP3. Did you not have to supply sa/sysadmin credentials to apply the service pack?

Have you verified that...

I'll definitely be interested in hearing what you find out.

It does seem like it would be a rarely hit bug, but, based on my recent experience with deletes, I think it is probably more common than MS thinks. ...

I think you need a query like this:

SELECT

D.key_no,

D.org_code,

D.test_data,

D.status_code,

DT.org_code,

...

Hmm, interesting. Since I can't duplicate this I have no idea why it would be blank. The source for sysprocesses and sys.dm_exec_sessions are different so the difference must...