There are was to capture the missing stats. First thing that comes to mind is to run an Extended Event session to capture all of the missing stats notifications.

Yes the cleaner in the server room unplugging a server has happened - sad but real.

Don't forget to check the Host logs if this happens to be a...

Big question, are these separate physical drives? 600GB is not very much to work with for a database.

The partitioning mechanisms are largely the same. As Rod suggested, check the dmv to ensure no other enterprise feature is in use prior to attempting the restore.

Here are...

I have noticed that as well. I was very close to submitting a response before noticing the date. I could go with latest being the most recent 7 days.

socks

Hmmm. So should the 404 now read Sock Not Found?
:Whistling:

I think the others have hit on it pretty well so far. I believe this instructor has missed the mark. Making every column the same length is the same kind...

This one may be a lot better for help in learning partitioning.

https://www.brentozar.com/archive/2013/01/sql-server-table-partitioning-tutorial-videos-and-scripts/

You are welcome.

Why stop at SQL Server 2012? Very soon, 2012 will be three generations behind. There are so many improvements from a stability and performance standpoint to SQL 2016, I don't...