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

Scripts by Federico Iori

SQLServerCentral.com profile

   Items 1 to 13 of 13   
 

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,477 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,117 reads

SCD Implementation with TSQL

ETL for a SCD using only TSQL, without hash functions  Read more...
By Federico Iori 2012/11/13 | Source: SQLServerCentral.com | Category: scd
Rating: |  Discuss |   Briefcase | 1,065 reads

Quantization of an RGB color code into a palette

Quantization of an RGB color code into a palette  Read more...
By Federico Iori 2012/11/14 | Source: SQLServerCentral.com | Category: color palette
Rating: |  Discuss |   Briefcase | 436 reads

Equivalente of LAG/LEAD for SqlServer2005/2008

Is possible to get similar result as analytic function LAG/LEAD using operator APPLY  Read more...
By Federico Iori 2012/06/18 | Source: SQLServerCentral.com | Category: lag
Rating: (not yet rated) |  Discuss |   Briefcase | 685 reads

Expanding identity to negative values

Identity integer can be max 2mld, if the table has many rows I can expand the identity.  Read more...
By Federico Iori 2012/02/10 | Source: SQLServerCentral.com | Category: identity property
Rating: (not yet rated) |  Discuss |   Briefcase | 564 reads

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,159 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 | 656 reads

TSQL fast unix timestamp conversion

How to convert Unix timestamp into datetime taking into account also summer or winter time  Read more...
By Federico Iori 2011/12/02 | Source: SQLServerCentral.com | Category: timestamp
Rating: |  Discuss |   Briefcase | 445 reads

Convert string Hex to Numeric with inline TSQL

A fast way to convert a string containing Hex values to numeric  Read more...
Rating: |  Discuss |   Briefcase | 1,243 reads

View all table and index partition

This view shows range limits, number of rows and filegroup for each partition for each table  Read more...
By Federico Iori 2011/05/09 | Source: SQLServerCentral.com | Category: partitioning
Rating: (not yet rated) |  Discuss |   Briefcase | 1,189 reads

Populate partition

Fill a specified partition of a table with a specific query, working on staging table   Read more...
By Federico Iori 2010/03/25 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 703 reads

Rebuild partition

Rebuilds online a table partition with all indexes   Read more...
By Federico Iori 2010/03/12 | Source: SQLServerCentral.com | Category: rebuild
Rating: |  Discuss |   Briefcase | 1,679 reads
   Items 1 to 13 of 13