I want to leverage the cores and SSDs on our servers to improve parallelism in T-SQL. I’m seeing lots of cores sitting idle and Disk IO at a fraction of its aggregate throughput during long-running processes. In the days of mechanical drives, things used to be universally bound by Disk IO and with the exception of sorted parallel bcp ops loading to different filegroups, we would execute our steps in sequence.