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 »
I'm Presenting at SQL Saturday #160
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 »
Introduction to Partition Switching
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 »
Indexing Data Warehouses in SQL 2012
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 »
Checking IP Against CIDR Netmask with T-SQL
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 »