Thanks for both of the thorough replies. I’m certainly not in the 8 million data rows per day camp so I’ll stick to keeping it simple 
You should blog on the topic (and likely many others), I sense you have a wealth of knowledge many of us could tap in to.