Eight hours of work in 20 minutes – partitioning rocks

Target Audience:

Database developers and database administrators with little or no experience with table partitioning.


If you ever experienced an ETL process getting slower and slower, this might be it. Partitioning and partition switching. Once an enterprise feature. Now in every edition of SQL Server.
I’m going to be very hands-on. I’ll reveal some of all the mistakes I have made.
I’m even going to show you the silver bullet that solves all your problems. Nah. Not really.
But I WILL show you how partitioning works. I will even show how “poor man’s partitioning” used to work, back when “true” partitioning was Rich People’s feature.
Since not even partitioning is a free lunch (sorry…), you will get some friendly advise on refactoring code by the end of it all.

Why I Want to Present This Session:

I thought it was kind of cool to cut 95% of the execution time for an ETL process, so I created this presentation for my colleagues.

Additional Resources:

Thanks for letting me present at GroupBy, I had a great time!
My presentation and demo material is here: www.tsql.nu/presentations

The following two tabs change content below.

Magnus Ahlkvist

Database Consultant, CEO at Transmokopter SQL AB
Database consultant, with my own company "Transmokopter SQL AB". I have spent the past 20 years working with databases, mainly SQL Server, and I still find myself learning. I like to share the things I did learn and even more so all the things I have done wrong (and corrected). In love with the SQL community, enjoying every second whenever I get a chance so contribute.

Latest posts by Magnus Ahlkvist (see all)

Previous Post
CI and CD with SSDT and Living to Tell about It
Next Post
12 Months of Self-employment, Lessons Learned

2 Comments. Leave new

Eugene Meidinger
September 14, 2019 9:18 am

This is an interesting session. As someone who has never implemented partitioning, I had a little bit of trouble following your abstract. For someone like me, some short explanations of why partitioning improves performance and what counts as “poor man’s partitioning” would be quite helpful. It’s easy to think this session is only for advanced users, but I suspect I would actually learn a lot from watching it.

    Magnus Ahlkvist
    September 14, 2019 10:06 am

    Hi, and thanks for the comment! I was struggling with keeping the abstract short without leaving too much information out.


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.