Backups from the secondary are somewhat redundant, and as you're discovering, not really possible. You can only run a FULL, proper, backup from the current primary. You can run log...

This is a known behavior. I reported it as a bug a while back. Microsoft has supplied a work around. You can enable TraceFlag 272 on your server. There are...

Nicely done. Just curious why you aren't using the Dynamic Management Views (DMV) to retrieve a lot of that information?

Please, get rid of all the query hints, then start tuning. Index hints, especially for a query that is not that complex, shouldn't be necessary. There's no way to validate...

Sean Lange (7/19/2013)

---

We have from time to time started heading in a bad direction. The good news is that there always seems to be a few people around here who...

I wrote a query that solves this problem for our SQL Monitor tool. You should be able to modify it for your own uses. Here's the query.[/url]

I was doing some research this morning and got sucked down a rabbit hole (it happens) and landed on a series of sites complaining about Stack Overflow and Stack Exchange....

Erland Sommarskog (7/18/2013)

---

I'm not sure that I know what Grant is talking about. There some changes to the optmizer, as described in Books Online:

Query plans

SQL Server 2014 includes substantial improvements...

Koen Verbeeck (7/17/2013)

---

Grant Fritchey (7/17/2013)

---

While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be...

You should be able to just connect and query the database from Excel. You just use the login that lets you at the data. I've done this from Excel (and...

I don't know that this will help much, but, I'd look at the properties on the SELECT operator. Is the optimizer completing optimization or is it timing out? If the...

Rebuilding the index defragments the indexes and updates the statistics using a full scan against the data. Then, you're updating statistics. So, the question is, how is that second update...

While I haven't been able to test it at all yet, there is supposed to be a radically improved statistics engine within 2014. That could be a compelling reason to...

Third!

ERLAND!

Welcome to the forums at SSC.

I think that what you're seeing is a result of Steve experimenting over time with the structures of the forums. But, I don't think he...