Re: stored proc bug with datetime variable
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 14 Sep 2006 21:14:23 +0000 (UTC)
ujjc001 (ujjc001@xxxxxxxxx) writes:
Ok, so I read
http://blogs.msdn.com/queryoptteam/archive/2006/03/31/565991.aspx and
it make sense but why then, was the SP'd call slower if it would have
recompiled vs the call in a raw query? I would assume that my date
column stats were messed up? Would that seem logical?
I will have to ask for apologies, but could you post an example to
clarify your question? I'm not sure that I understand it.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- stored proc bug with datetime variable
- From: ujjc001
- Re: stored proc bug with datetime variable
- From: Erland Sommarskog
- Re: stored proc bug with datetime variable
- From: ujjc001
- stored proc bug with datetime variable
- Prev by Date: Can I avoid temp tables, etc.
- Next by Date: Re: Can I avoid temp tables, etc.
- Previous by thread: Re: stored proc bug with datetime variable
- Next by thread: Query is slow sometimes
- Index(es):
Relevant Pages
|
