(Michael J. Swart) The best way to avoid tempdb GAM and PFS contention caused by table-valued parameters (TVPs) is to use Memory-Optimized Table Variables.
Read More - Register for Free Membership
(Michael J. Swart) The best way to avoid tempdb GAM and PFS contention caused by table-valued parameters (TVPs) is to use Memory-Optimized Table Variables.
Read More - Register for Free Membership