I've never seen this error. Wish I could offer more help.

That's actually a syntax I use sort of. The JOIN order is being enforced by the order of the ON clauses. I basically never user RIGHT JOIN's but...

I haven't done this in quite awhile, but I will say it sounds like you are just covering over the root of the problem by this workaround.

Is there anything...

Take a look at the Cross Tab and Pivot links in my signature. I think they'll give you what you need.

jasona.work (9/11/2013)

---

I believe the answer to this next question is yes, but I'd like to be sure:

If I create an XE session on SQL2012 (for the GUI) and save it...

Can you provide some more details?

Interesting. I'd be more inclined to use a Server Side trace or XEvents to see if a database is used.

I don't think using the last_user_update column would be the best...

L' Eomot Inversé (9/7/2013)

---

Is there any indication whether their "will not fix" applies just to 2011 or does it cover 2014 too, so that we can expect to see no...

WayneS (9/10/2013)

---

SQLRNNR (9/9/2013)

---

Jack Corbett (9/9/2013)

---

Hey is anyone going to be at the SQLSaturday this week in Orlando or next week in Providence? If you are be sure...

andybellenie (9/10/2013)

---

Here we go.

I've not included the exclusion lists or any filters for now as they don't seem to be having significant impact at this time, and also the...

Eddie Wuerch (9/10/2013)

---

Weird that it's deadlocking on a page. Since you have the page address (5:1:1662692), it would be nice to see what the actual deadlocked resource is.

Print the page...

The first thing I noticed is that the Isolation Level is serializable which will cut down on your concurrency quite a bit. I'd be looking into the reason...

Well, sp_who2 is shipped by MS with SQL Server and gives a consistent set of data and will be available on all SQL Servers. sp_whoisactive is a great tool...

In my opinion, it always better to jump ship before it sinks and if you see the ship sinking and can get out you should. So you are taking...

I'd agree that asking what is relevant to a particular error number is silly. Very few people I know have error numbers memorized since you always get some kind...