How to use TFS in SQL Server Management Studio
Monday, May 16, 2011
Views are also known as virtual table, you can improve performance by creating a unique clustered index on the view.
Using the NOEXPAND View Hint
SELECT Column1, Column2, ... FROM Table1, View1 WITH (NOEXPAND) WHERE
at 10:33 AM