• Just remember three main things about SSD's before you run off and start putting stuff on them:

    1. SSDs tend to wear out. The individual bits can’t be erased and written to again after a while. Flash memory has a limited number of times that data can be written to a location.

    2. SSDs are expensive: The price per gigabyte is significantly more expensive than traditional drives. For example, a 2TB HDD costs around $100, which is exactly how much a 60GB SSD costs. You get way more storage for your buck with an HDD. SSDs are more expensive to produce, so the MSRP tends to be higher than that of HDDs.

    3. SSDs has lower storage capacity: Compared to HDDs, SSDs have much less storage capacity. SSDs have not been made in real high capacities yet to my knowledge. So, you will probably have to spend more money for more storage.

    Also, regarding TEMPDB please remember that tempdb is write heavy, and SSD's have a limited write life. I'm not saying that this can't work, people are doing it, I'm just saying it is something you need to be aware of. 😀

    "Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"