Note: This post was originally published on my old blog site,

Last night I had the pleasure of presenting at the Arizona SQL Server User Group meeting.  I was called in to present at the last minute, and I gave a session titled “Partitioning For the Win! An Introduction to SQL Server Partitioning“.  Here’s the session abstract:

Are you using your hardware wisely?  Are you getting the best possible performance out of your data warehouse?  Fed up with long maintenance cycles?  Partitioning may be the solution you’ve been looking for!  This session will introduce you to Partitioning using simple examples and will describe how you can get the most out of this feature of SQL Server.

I enjoyed presenting this session, which was packed with LEGO references and some scripts to help users who are new to partitioning experiment with this feature.  Click here to download the presentation and scripts in .zip file format.

If you attended the presentation and would like to share feedback (especially suggestions for improving the presentation) please add a comment below.

Thanks to Amy Lewis (t) for inviting me to present, and thanks to all of those who attended!