SQL Server: String parameters for JSON values have varying lengths
Open
area-json
area-perf
consider-for-next-release
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
For example:
```
@p0='[{"Name":null,"Names":null,"Number":0,"Numbers":null,"OwnedCollectionBranch":null,"OwnedReferenceBranch":null}]' (Nullable = false) (Size = 111)
```
We generally avoid this for string parameters because it causes cache pollution. Instead, we set the max length explicitly to either the defined max length, or the maximum allowable for the store type.
Contributor guide
Assessment
This issue has not been assessed yet.