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

Scripts with tag dimension Rss

Search for any content tagged dimension

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 3 of 3   
 

Insert new values in dimension avoiding deadlock

TSQL code deadlock-safe for inserting new value into dimension  Read more...
By Federico Iori 2012/02/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 1,268 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 | 694 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2016/01/01 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 10,888 reads
   Items 1 to 3 of 3