https://www.insidesql.org/blogs/cmu/?disp=comments de-DE http://backend.userland.com/rss 60 Fri, 26 Jul 2013 09:32:52 +0000 cmu c2349@https://www.insidesql.org/blogs/ Genau der war es! Hier noch die Infos aus dem KB-Artikel: Enabling trace flag 4136 disables parameter sniffing, which is equivalent to adding an OPTIMIZE FOR UNKNOWN hint to each query which references a parameter. Queries that meet any of the following conditions still undergo parameter sniffing even if the trace flag is set. • The parameter is specified by using the "optimize for (@p = <value>)" query hint. • The query uses the "option(recompile)" query hint. • The query is a part of a stored procedure that uses the "with recompile" option.</value> )" query hint. • The query uses the "option(recompile)" query hint. • The query is a part of a stored procedure that uses the "with recompile" option.]]> https://www.insidesql.org/blogs/cmu/sql_server/parameter-sniffing-und-trace-flag-4136#c2349 Fri, 26 Jul 2013 09:23:48 +0000 tosc c2348@https://www.insidesql.org/blogs/ Wenn mich nicht alles täuscht, war das der KB <a href="http://support.microsoft.com/kb/980653">http://support.microsoft.com/kb/980653</a> http://support.microsoft.com/kb/980653]]> https://www.insidesql.org/blogs/cmu/sql_server/parameter-sniffing-und-trace-flag-4136#c2348