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...
Date: 05/23/2017
Partitioning of Temporal Tables in SQL Server 2016
Microsoft SQL Server 2016 introduces system-versioned temporal tables, which allow for...
Date: 01/20/2016
Partitioned Table Framework (PTF) Project has been published on CodePlex
Today I did publish the PTF project on CodePlex (see https://ptf.codeplex.com/) which consists of a...
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...
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...
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...
Date: 08/21/2009