All Questions
Tagged with parameter-sniffing query-optimization
4 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
0
votes
0
answers
388
views
Filter the data inside a stored procedure using Table-Value parameters
I have a stored procedure which receives multiple table-type parameters and I want to filter the data using those parameters. The problem with that is those parameters can contain no rows and in that ...
0
votes
1
answer
183
views
Parameter sniffing degrades stored procedure performance
I'm using SQL Server 2012. Recently I'm have performance issue on all my stored procedures, the code inside the procedures work very fast though.
I found something about parameter sniffing so I used ...
- 6,703
0
votes
2
answers
132
views
Getting around cached plans in SQL Server 2005
Can someone please explain why this works. Here is the scenerio. I have a stored proc and it starts to run slow. Then I pick a parameter and declare a variable to house its value and in the proc ...
- 1,038