And no one has even mentioned DISTINCT yet.

Everything Luis says plus...

You have functions all over the place in your JOIN and WHERE criteria. These are going to absolutely prevent the use of statistics causing the execution plans...

It sounds like you're getting a parallelism deadlock. Hard to say for certain without seeing the deadlock graph.

Just because you see indexes in the execution plan doesn't mean they're...

I'm with Sean. It sounds like you're not running the ALTER PROCEDURE script but instead you're executing the procedure itself. Those are two distinct steps.

Troubelshooting SQL Server [/url]is a great book.

For just general administration, I wrote part of a book.

Cost Threshold for Parallelism

You change it as...

Tobar (4/8/2014)

---

Arrgh. Sorry. I keep thinking those are input parameters, not output.

Another issue I had is that you can not just "compile" (execute) a CTE definition by itself without some...

yuvipoy (4/8/2014)

---

Grant.! Good Point to know.

What about DTA statistics ?

are they not statistics?

How DTA able to do get those details(Statistics), which means that it was missed by Auto...

For scripting the logins, follow the suggestions here. You should be able to just right click on the linked servers and generate a script.

AUTO_CREATE means that when a query is run against the database and there are no statistics for a column in a WHERE clause, a JOIN, or other areas where statistics...

Thank you!

Good luck on setting up the virtual network. It can be a little tricky at times, but the documentation I sent does work. I've used it a couple of...

What is the "requested operation" that you're trying to do?

As was stated, it's not about avoiding it or not. It's about whether it's appropriate or not. But, one thing you should change is the default value for Cost Threshold...

For what you want to do you're looking at Virtual Machines. SQL Database is just a relational data store, a platform as a service. You need actual infrastructure. You'll also...

yuvipoy (4/8/2014)

---

Originally my question was on that one only.

Later when i came across these thing had doubts how these statistic are working in DTA.

Here comes another question, if the recommended...