All Questions
Tagged with parameter-sniffing query-hints
2 questions
4
votes
2
answers
765
views
Does Sql Server 2014's "Hekaton" compiled stored procedures address parameter sniffing issues?
SQL Server 2014's "Hekaton" in-memory table optimization proclaims, "Native compilation of business logic in stored procedures." Because of issues with "parameter sniffing" (see here and here) in SQL ...
- 7,701
7
votes
3
answers
5k
views
How do I control parameter sniffing and/or query hints in entity framework?
I have a problem where one of my Entity Framework (EF) queries is taking a very long time to execute in Sql Server, although when I copy-and-paste the generated TSQL into Sql Server Management Studio (...
- 7,701