All Questions
Tagged with parameter-sniffing azure-sql-database
2 questions
0
votes
1
answer
138
views
Mysterious query running from where?
My application is issuing the following query:
(@orgId bigint,@contractNumber nvarchar(12))
Select top 1 *
From ReceivableCut c with (nolock) ...
- 11.4k
4
votes
4
answers
4k
views
Query is slow when using parameters but fast when using literal
I have a query that runs against a pretty large table, I need to do a count on it.
If I use a literal the query runs in a few seconds but when I put the values in as variables (which I need to do) the ...
- 375