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

Are you sure the log backups and the full/differential are from the same database on the same server? There has to be a log that overlaps with the LSN on...

You could try doing the insert into the new table without having the key in place and then apply the key after the data is loaded. In some situations you...

sys.dm_exec_requests will show the execution of the query and any waits that it's experiencing as well as any blocks.

I'd suggest looking at the combined execution plan. It might be different...

If you aren't using them, cleaning them up isn't going to hurt anything.

Is the book by Denny Cherry? If so, I'd take it's word as pretty near to gospel.

sdownen05 (4/4/2014)

---

Keith,

First, thanks for pointing me to the other scripts. I will definitely start using them instead.

As to your query, it shows that the table exists. However, when I do...