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...

Not so sure about #3. Why not? After SQL Server does the compression, it's just a file.

One other one though, prior to 2014, you can't encrypt and compress using native...

balasach82 (4/8/2014)

---

Awesome. A job ws running which was running the query. Thanks for pointing to the problem.

So, its 100% sure that an sp_execsql does not pass control untill the query...

There is no right answer for this. It's very subjective. Also, you'll not find any tool that monitors all those services equally well. Further, some of the best tools for...

Performance is most often related to the code or the structure. But, sometimes it can be other things. For example, do you have any process for maintaining statistics on your...

Extended Events can be used to audit just about anything... BUT, if you have 'sa' privs on the server, you can turn off ex events. If you absolutely have to...

Shrinking the file or the database is reclaiming space that was allocated in the database, but is not currently in use. Compression is taking a value and making it smaller...