You are here: Re: Same query - different execution plans?? « MsSQL Server « IT news, forums, messages
Re: Same query - different execution plans??

Posted by sqlgirl on 07/16/07 23:49

Hi, thanks for the information. Is ARITHABORT the only setting we need
to be concerned with?

We ran a test. Cleared out the cache entry for our sp by altering it.
Verified that it was no longer listed in syscacheobjects.

Next, we ran the query from QA, it added an entry to syscacheobjects.
Then, we ran it from excel. It still creates a second entry in
syscacheobjects.

Which still leaves me scratching my head.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация