79828877

Date: 2025-11-24 16:31:33
Score: 1
Natty:
Report link

I’ve updated the post and included the implementations I tested. I haven’t tried Microsoft.Data.SqlClient.SqlBulkCopy yet. Since the T-SQL BULK INSERT approach didn’t provide any performance improvement over the Azure Data Factory implementation—and scaling from General Purpose (12 vCores) to Business Critical (8 vCores) also didn’t improve ADF performance—I’m starting to wonder if there are other hidden limits causing this bottleneck

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: Bill