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.
Thanks for letting me present at GroupBy, I had a great time!
My presentation and demo material is here: www.tsql.nu/presentations
Latest posts by Magnus Ahlkvist (see all)
- Eight hours of work in 20 minutes – partitioning rocks - September 5, 2019