Microsoft SQL Server Inside Out

In this series of blog posts I'll present my experiences gained in 15 years of supporting of SQL Server at Microsoft. SQL Server Books Online is a great resource for reference material, but sometimes prooves akward for getting a fast start on a new fe

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

Author: HansPo Date: 05/23/2017

Partitioning of Temporal Tables in SQL Server 2016

  Microsoft SQL Server 2016 introduces system-versioned temporal tables, which allow for...

Author: HansPo Date: 01/20/2016

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

Today I did publish the PTF project on CodePlex (see which consists of a...

Author: HansPo Date: 11/09/2012

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

Author: HansPo Date: 01/10/2011

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

Author: HansPo Date: 11/29/2010

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

Author: HansPo Date: 08/21/2009