Materialized views in SQL Server are equivalant to Indexed views.
Below links have More details:
Creating indexed views in SQL Server
Advantages and disadvantages of indexed views
How to create materialized view in sql server?
Example:
[sql]
CREATE VIEW vwTest
WITH SCHEMABINDING
AS
SELECT id, name FROM Products where id > 1000
GO
–Create an index on the view.
CREATE UNIQUE CLUSTERED INDEX ix_vwTest
ON vwTest (id)
GO
[/sql]