L' Eomot Inversé (3/14/2013)

---

Well, you were five hours late then. And even if you...

Happy Pi day.

No errors posted in any log?

Not in the storage logs?

Not in the OS logs?

Not in the SQL logs?

If not in any of those places, then maybe somebody has created a...

Lynn Pettis (3/14/2013)

---

TheSQLGuru (3/14/2013)

---

Hmm, I wonder what happens if the codeid's repeat instead of being unique across all 3 code tables. Hopefully the way the aggregates are done will...

Very good point Steve. Checkdb is insurance. I just ran into two clients (new) in the same day with some level of corruption in their databases. Neither...

Oftentimes you need to place a derived column transformation to force the conversion.

+2

Has the maintenance plan worked in the past?

Does it throw the same error no matter where you try to open it (your desktop or from the server)?

Is it throwing any errors into the error logs? Please post the errors.

shannonjk (3/13/2013)

---

That is odd that the merge should be faster than the hash, since if I add hash to the join (i.e LEFT HASH JOIN) it executes in half the...

Grant Fritchey (3/13/2013)

---

SQLRNNR (3/13/2013)

---

It might be typical for your environment. But that doesn't mean it has to be acceptable.

That many parallelism deadlocks can mean that you have a lot...

Grant Fritchey (3/13/2013)

---

SQLRNNR (3/13/2013)

---

You are dealing with a Debbie Downer.

XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information...

And also what the desired output should look like?

Replication won't affect the logins on the either server. Replication won't affect the database users either, on the subscribing server.

It might be typical for your environment. But that doesn't mean it has to be acceptable.

That many parallelism deadlocks can mean that you have a lot of poor performing...