You're assuming right. This is precisely the warning that I received in 2014. But can I ask you more questions related to this. What is trace # for 2008R2 and...

For work that's done in June, they pay usually in the middle of August. They explain it as a lot of paperwork is involved and delays from a client. But...

Wouldn't it be just easier to run simple select * from sys.sysprocesses where blocked>0 ?

Thanks. Now I got it.

But I am still thinking how can I use it. It's XML in text format, all in one long line and I can hardly figure...

This is a query that I ran now. I took it from DMV book and modified it. It uses sys.dm_exec_text_query_plan

SELECT detqp.dbid ,

...

Jacob Wilkins (4/19/2016)

---

Another reason I've run across surprisingly frequently is that the plan shows up NULL if you have a stored procedure with conditional branches that query temporary objects, and...

No, no, no, I don't do it on production system. It's on a test server that's refreshed nightly from production.

Recreated S.P. with recompile, but the problem is still the same.

Now...

Thanks Alan, for detailed explanation.

I always thought that parallelism is about I/O, with dedicating a CPU to each I/O stream. If it's about CPU, it looks that in my case...

Great! Finally it worked for me. Thanks a lot.

Thanks for advise, but unfortunately I don't have so many servers to connect to in order to push out the old ones.

And hacking the Registry I think is rather...

There are couple of bugs in this script, but otherwise it's very thorough, very comprehensive security settings as well as recommendations report.

If not bugs, would put 5 stars certainly.

Hugo Kornelis (1/21/2016)

---

But a way more important question is what you/they are trying to achieve. If the report is such that some margin of error in the numbers is acceptable,...

My table is 200 GB, and also other tables and indexes are partitioned in the same file-groups. Anyway, I will test it in dev environment before doing it in prod.

Smart idea. I will try it. I also have secondary indexes partitioned.

Thanks. This works. I just added another pipe next to col4.