Questions tagged [simple-parameterization]

Simple Parameterization is associated with SQL Server execution plans that are produced in the Trivial phase. It results in one or more literal values being replaced by parameters.

Filter by
Sorted by
Tagged with
2
votes
0answers
40 views

SQL input parameters filtering on indexes are defaulting to nvarchar causing full table scans [migrated]

When our applications are submitting SQL via ADO.Net, with input parameters, the parameter definitions are defaulting to nvarchar. If that field is defined as a varchar, and an index, on the database ...
0
votes
0answers
57 views

Why additional plans are created under simple parameterization?

I have a table which has 2163 rows and clustered index on id column. I run the following queries: select id from ticket_attach where id = 1 select id from ticket_attach where id = 2 select id from ...
1
vote
1answer
3k views

AlwaysEncrypted error when inserting via stored proc

lets start with the error first: Encryption scheme mismatch for columns/variables . The encryption scheme for the columns/variables is (encryption_type = 'PLAINTEXT') and the expression near line '3' ...
8
votes
1answer
336 views

Why does a plan with FULL optimization show simple parameterization?

I read that only Trivial Plans can be Simple Parameterized, and that not all queries (even when the plan is Trivial) can be Simple Parameterized. Then why is this plan showing Full Optimization, and ...