GilaMonster (9/14/2014)

---

Sometimes advice on a blog still scares me. Not often, but sometimes. Like today

Consider using a RAMDisk for Index filegroups.

Putting non-clustered indexes on a RAMDisk will greatly improve performance

Be absolutely sure that your RAMDisk either backs itself up to disk, or at least saves and loads itself from a real disk on shutdown and startup.

This can significantly increase shutdown/startup/reboot times.

I also recommend doing regular SQL backups of these filegroups.

If the system crashes, recovering the database becomes a lot harder. Which is why backups are very important.