Solved

Materialized views

Posted on 2011-03-02
2
295 Views
Last Modified: 2012-05-11
Hi

what is the alternative for Materialized views in Sqlserver 2005.

Thx
Naren
0
Comment
Question by:knaren1975
2 Comments
 
LVL 15

Expert Comment

by:derekkromm
ID: 35018104
What exactly are you trying to do?

The "alternative" is to simply create a table with the same structure as the view and insert into it from the view, possibly with some sort of dating or other historical indicators if necessary.

0
 
LVL 39

Accepted Solution

by:
lcohan earned 250 total points
ID: 35029354
The "alternative for Materialized views in Sqlserver 2005" is "Indexed view" - please see details below:


http://technet.microsoft.com/en-us/library/cc917715.aspx
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question