Hi John,

Thanks for the reply. I have a few comments:

I know technically a table without a clustered...

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