Creating Partitions Using Dynamic SQL
Recently I wrote a post on partition switching, however, one of the big pieces I left out was how to go about properly partitioning your database »
Recently I wrote a post on partition switching, however, one of the big pieces I left out was how to go about properly partitioning your database »
Great news! I found out this week that I will be presenting at SQL Saturday #160. During my presentation I will be covering how to load »
Quite often when building a data warehouse we are given the challenge of having to delete existing data before importing the latest and greatest. In an »
This week I was at the Detroit MTC for a SQL Server 2012 release event where Rick Brewis (Microsoft) and my friend Josh Fennessy (BlueGranite) presented »
I’ve been in the process of improving the functionality in ASLB, one of the improvements I have been working on adding is functionality for ASLB »