Tag: csharp

Use table partitioning to dramatically speed up queries on large datasets.

Use MERGE (upsert) for safe, rerunnable data pipelines that handle duplicates gracefully.

Calculate running totals, rankings, and moving averages efficiently with SQL window functions.

Replace Task with ValueTask in frequently-called async methods that often complete synchronously.

Rent and return arrays from a shared pool to avoid repeated allocations in buffer-heavy code.

Eliminate heap allocations when parsing strings by using Span for memory-efficient operations.