Partitioned Table Framework (PTF) Project has been published on CodePlex

Today I did publish the PTF project on CodePlex (see which consists of a set of T-SQL stored procedures for managing partitioned tables in SQL Server. These procedures may be used in your SQL Agent Jobs or SSIS SQL Tasks that load data into staging tables of your data warehouse and then switch these tables into partitions…


Inside of Table and Index Partitioning in Microsoft SQL Server

    Introduction   With those huge fact tables, you typically find in today’s data warehouses, you’re often confronted with restrictions concerning the manageability of these tables and their indexes. Some actions like generating full database backups, checking the database consistency, or reorganizing indexes are becoming prohibitive in terms of time required to perform these activities….