How to use
TFS in SQL Server Management Studio
Monday, May 16, 2011
What is Indexed view in MS SQL Server
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
http://msdn.microsoft.com/en-us/library/aa933148(v=SQL.80).aspx
Subscribe to:
Posts (Atom)