Prev: SQL Query needed
Next: Manipulation of date ranges
From: sam on 24 Apr 2010 01:51
Why Parameter Sniffing is Not happened in Each Query of SQL.Why its
only occur in some query.I Wrote Stored procedure more Complex that
the Stored Procedure Which Have Problem of Parameter Sniffing.But All
those Working fine
From: Erland Sommarskog on 24 Apr 2010 06:08
sam (sumesh.jangra2009(a)gmail.com) writes:
> Why Parameter Sniffing is Not happened in Each Query of SQL.Why its
> only occur in some query.I Wrote Stored procedure more Complex that
> the Stored Procedure Which Have Problem of Parameter Sniffing.But All
> those Working fine

If you have a stored procedure where you think parameter sniffing is
not happening, please share the code and why you think it does not happen.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: SQL Query needed
Next: Manipulation of date ranges