Actually I got stuck while searching a materialized view approach in SQL Server. My problem was that I have two databases and I have created some views whose functionality is to read data from one DB to another.
For instance, a view in DB "A" is picking up the data from DB "B". It worked perfectly, but suddenly today I got
Null pointer exception. When I traced the problem, I found that My DB "B" has crashed. I searched and found that in Oracle, there is support of this problem by Materialized views whose functionality is to restore the old view state in case of crashing of one DB. But I didn't find anything like this in SQL Server.
I am really stuck in this issue. Any help would be greatly appreciated.