With regards to SSD performance tailing off...

This has been improved with the implementation of the trim command. I know Windows 7 uses it, but don't recall if any server...

In memory tempdb would be nice, except when you don't have enough memory.

I'm working with a good sized database (~300+GB with indexing). Our server is a bit...