Works fine with small data.
Why
TempDB contention.
Fix
Use table variables for small datasets.
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.
Works fine with small data.
Why
TempDB contention.
Fix
Use table variables for small datasets.