That it might be legal right now in your locality does not magically make it a good idea, nor does it make it possible to plan a thing when you...

• This reply was modified 3 years, 10 months ago by  aaron.bertrand. Reason: Grammar
• This reply was modified 3 years, 10 months ago by  aaron.bertrand.

I don't have enough information from that screen shot to conclude anything. Can you post the entire actual post-execution plan to answers.sqlperformance.com?

As for resources on learning...

Hi muzikfreakster, in order to use Index Analysis, you must generate an actual or estimated plan from within Plan Explorer - this is just one of the many pieces of...

Microsoft is aware of the problem, and as I said, the doc should be fixed soon.

It *is* supported on BI Edition. The docs are merely incorrect and should be updated soon.

What is "sad news"? Microsoft hasn't announced anything officially; in my admittedly naïve interpretation they're just dragging their feet a bit on releasing final service...

Steve Jones - SSC Editor (1/28/2014)

---

Good points, Aaron, and I agree with you that I want CUs and quality has been good. However the caveats about support, and the fact...

As a counter-point,...

Nadrek (1/28/2014)

---

Microsoft is encouraging us to pay continuous per-year fees (like the EA agreements for SA licensing), taking that money, and then failing to provide us with properly tested updates...

Of course, CUs are called cumulative updates - this is not a cute name; they're actually...

Don't forget Steve, that this is also how we got Service Pack 4 for SQL Server 2005 (and you were the initiator):

http://connect.microsoft.com/SQLServer/feedback/details/522122/service-pack-4-for-sql-server-2005

I think it's important to retire a version with...

Sorry coach, as I'm clearly labeled a "rookie" here, I didn't know URLs wouldn't automatically become clickable.

Please try installing Cumulative Update #3 on the SQL Server 2012 instance. This specific problem is highlighted here:

http://support.microsoft.com/kb/2725950

The CU is available for download here:

http://support.microsoft.com/kb/2723749

Also you may have some interesting observations about other objects that are contributing to the size of sysobjvalues. Again connect as DAC:

CREATE TABLE #x(name NVARCHAR(511), c INT, l INT);

DECLARE

As posted here: http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/thread/68bd166f-c9b1-4f21-b997-8b44a8cffedb

My guess is that you have created large modules in msdb. See what this yields (you may need to connect using a dedicated administrator connection,...