Questions tagged [sql-server]
Questions related to Microsoft SQL Server 2016 through 2022. Questions for older versions are off topic. If your question is version specific please tag it specifically for that version. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.
1 questions from the last 30 days
1
vote
2
answers
164
views
Why does a SQL Server stored procedure generate different execution plans depending on the parameter value?
I am testing query execution plan behavior in Microsoft SQL Server 2022 Developer Edition and SSMS 20.2.1
Table:
CREATE TABLE Orders
(
OrderID INT,
CustomerID INT,
OrderAmount INT
);
...
- 189