SQLServerCentral - Scripts by Federico Iori

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

Rating: (not yet rated) |

Discuss |

Briefcase | 500 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 | 950 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 | 520 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 | 357 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 2011/11/09 | Source: SQLServerCentral.com | Category: hexadecimal conversion numeric inline fast

Rating:

|

Discuss |

Briefcase | 569 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 | 975 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 | 623 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,337 reads