SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag Indexed Views Rss

Search for any content tagged indexed views

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 4 of 4   

Block altering indexed views.

Altering an indexed view will drop all indexes on it without warning, even if nothing is changed. This will prevent accidental alters. Script is divided into 4 parts, included testing and cleanup scripts.  Read more...
By Dennis Post 2015/09/01 | Source: SQLServerCentral.com | Category: alter index
Rating: |  Discuss |   Briefcase | 942 reads

Enforcing surrogate key uniqueness in slowly changing dimension

Enforcing surrogate key uniqueness regards natural key in slowly changing dimension  Read more...
By Federico Iori 2012/01/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 725 reads

Roll Your Own Materialized Views

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

The Ultimate Object Searcher

Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.  Read more...
By Jesse Roberge 2009/10/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,125 reads
   Items 1 to 4 of 4