Creating Indexes on Computed Columns
http://msdn2.microsoft.com/en-us/library/ms189292.aspx
Creating Indexed Views
http://msdn2.microsoft.com/en-us/library/ms191432.aspx