What I outlined is pretty much it. Covering is more attractive. Adequate keys is attractive. Other than that, not sure what else to add. Make sure the statistics are updated...

Doa search right here in SQL Server Central. There are articles on restore all over the place, detailing different options and methods, pretty much everything you'd need.

Piling on with the suggestion on books. I helped co-author a book on basic SQL Server administration. There is a 2008 version, but the 2012 version will serve...

Please don't cross post. Most people who are likely to respond read across the different groups. Having the same conversation in multiple places just diffuses the information.

UPDATE STATISTICS all alone isn't going to affect your PLE. It's the changes that may result to execution plans when they have different (hopefully more accurate) row estimates that can...

So, right now I only have a bad answer.

The core issue is that RavenDB is, and I'm paraphrasing a little to make this more of a family friendly...

I'm checking with the developers.

Thank you!

I'm not sure then. Sorry I can't help.