SQLServerCentral - Scripts by Federico Iori

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,249 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/01/22 | Source: SQLServerCentral.com | Category: truncate

Rating:

|

Discuss |

Briefcase | 641 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 | 873 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 | 389 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 | 555 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 | 547 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,107 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 | 597 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 | 418 reads

Convert string Hex to Numeric with inline TSQL

A fast way to convert a string containing Hex values to numeric Read more...

By Federico Iori 2013/01/18 | Source: SQLServerCentral.com | Category: hexadecimal conversion numeric inline fast

Rating:

|

Discuss |

Briefcase | 1,162 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,113 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 | 676 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,564 reads