Blog Post

Azure SQL Blog
5 MIN READ

Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database

Arvind_Shyamsundar's avatar
Arvind_Shyamsundar
Icon for Microsoft rankMicrosoft
Dec 20, 2018
First published on MSDN on Aug 09, 2016 Reviewed by Panagiotis Antonopoulos, Jakub Szymaszek, Raghav Kaushik Always Encrypted is one of the compellin...
Updated Oct 28, 2022
Version 4.0
SQL Server 2016
SQLCAT
Nilavalagan's avatar
Nilavalagan
Former Employee
Mar 30, 2021

We are using this pattern in our scenarios and seeing latency issues with bulk copy as the concurrency goes up. When checked further on query store, we see the execution is waiting for memory grants.