Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Mark Stockwell

SQLServerCentral.com 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: SQLServerCentral.com | Category: first normal form
Rating: |  Discuss |   Briefcase | 1,656 reads

Roll Your Own Materialized Views

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