Instead of removing, try to tweak the num partitions, repartition and shuffle partitions to see if it increases the write speed. The Spark UI & DAG flow will exactly tell us the execution plan and we can see what's taking time to load the table to SSMS.