...yeah I couldn't think of any viable workarounds either.

Alan.B (9/15/2016)

---

Vendor Databases are generally not designed by database gurus which is a good thing, it helps keep us database people employed.

For a situation like this, clustered indexes, non-clustered...

Well, it's not that I want to do that,...

Ah, that makes perfect sense. 72 as a serial plan.....

As always, thank you. Also, I just watched your SQL Bits presentation on indexes. Very, very helpful!

Yes, these are great suggestions. Thank you, all!

I like it. Thanks again, Kevin.

I'd be interested to hear what some of those options for mitigating #1 are.

Currently, we're using Standard Edition........

Hi Kevin,

I've been looking into log-shipping since, honestly, you have me a little scared about the potential performance impacts of mirroring and transactional replication.

It seems to be a well-liked feature,...

Gail,

Thank you! I just wanted to make sure I understood the implications. I'll of course make sure I have good backups (and practice restoring them multiple times) before considering deleting...

Thanks, John.

I actually just read Gail Shaw's article yesterday, and I know that I'll need to talk to business users to determine RPO. However, my question is whether the incredibly...

John,

Thanks for the response. Two follow-up questions:

1) Let's say the steps were, at a high level:

a) Take full backup

b) Take differential backup

c) Take log backup (huge, needs to be shrunk)

d)...

Thank you, Kevin and others.

Ok great advice. Thank you!

One more question -- If I plan to use Ola Hallengren's maintenance scripts for full, differential, and transaction log backups (or even if I create a...

Thanks, Kevin! I've seen your sessions at SQL Saturdays before -- always very informative.

And just to clarify, you would recommend Log Shipping over mirroring or replication? Also, I assume that...

Gail,

I know you suggested,

"Tune your code, tune your indexes. If the views are nested, fix that first.

Consider some form of reporting server to offload the reports to."

I'm just curious--would you...