Possibly. If I remember correctly (and we're going off my memory, so Katy bar the door), they compress before they...

Eirikur Eiriksson (8/5/2014)

---

Guess one has to differentiate between five years of work and five years worth of experience. Questions like "what are the DAC limitations", "consequence of an idle connection...

sqldriver (8/5/2014)

---

Grant Fritchey (8/5/2014)

---

Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on the original. Then,...

If you have Enterprise SQL Server you can turn on compression

Short answer, costing. Has to be something in the calculation engine that makes that determination. Not something I know. Adam might. Paul probably would.

I'll bet if you compare costs by forcing plans to parallel using the trace flag, you'll see that, for whatever reason, the plans are higher in the systems where it's...

Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on the original. Then, it's all the...

I think it's a crazy requirement, but the only option you have is to rewrite the query without using the temp table. You could try using whatever query loaded the...

Nice.

We need one for DBAs.

The tools available within SQL Server for monitoring the VM level stuff (memory, cpu, some disk counters depending on your VM) are pretty much non-existent. SQL Server and it's tools...

GilaMonster (8/5/2014)

---

Koen Verbeeck (8/5/2014)

---

GilaMonster (8/5/2014)

---

In that case, for 5+ years...

Are you getting deadlocks or are you getting blocks. I'm unclear based on the information.

But, no, the situation you're describing sounds quite abnormal. I'd need to see more about the...

I asked the same questions I asked someone with 2-3 years of experience. I just expected better answers. Also, when we get to the open-ended questions, I expect answers with...

So far as I know, the approved method is to check to see if the server is the primary. I'm sure you could write a PowerShell routine that cycles through...

The differences between Standard and Enterprise could be part of it. There are options within the optimizer that are different there. But, it probably comes back to the available memory...