That's a good, simple answer Ian.

However if Koustav also wanted much more detail, there's a really excellent script at

http://www.sqlservercentral.com/Scripts/Maintenance+and+Management/31598

It will:

* allow you to put a whole list of...