Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Mark Stockwell profile

   Items 1 to 2 of 2   

1NF View Generator

Creates a view/select statement for given transactional table using foreign key info. Great for ETL extraction or History table routine.  Read more...
By Mark Stockwell 2011/06/27 | Source: | Category: first normal form
Rating: |  Discuss |   Briefcase | 1,696 reads

Roll Your Own Materialized Views

Simple but elegant alternative to indexed views. 
By Mark Stockwell 2010/02/11 | Source: | Category: materialized view
Rating: |  Discuss |   Briefcase | 1,297 reads
   Items 1 to 2 of 2