It’s never too late for Partitioning your Tables

Only a few developers design their tables for partitioning from ground up, simply because they do not envision that a table once might become so big that partitioning would become a real advantage. And even if they do, the fact that partitioning is an Enterprise-only feature (at least until SQL 2016 SP1) keeps them away…


Partitioning of Temporal Tables in SQL Server 2016

  Microsoft SQL Server 2016 introduces system-versioned temporal tables, which allow for automatically keeping a history of data changes in a separate history table and to retrieve the status of your data at any time in the past. Here I don’t want to go into all the gory details of their implementation. See the relevant…


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…


Hardening an ASP.NET session state database

Recently I did come across a problem with the ASPState database of ASP.NET. This database is used to store the ASP.NET user session data in a SQL Server instance. The database is being installed by executing Aspnet_regsql.exe with parameter –ssadd (see Session-State Modes). Principally there are two configuration modes: persistent and non-persistent, the latter being…


New Limit for Number of Partitions in SQL Server 2008 SP2

Good news for all that suffered from the 1.000 partition limit inherent with the current table partitioning implementation in Microsoft SQL Server 2005 and 2008. With the release of SP2 for SQL Server 2008 the bar has been raised to a new threshold of 15.000 partitions, which should be enough for daily data loads and…


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….