spoke to my boss about doing that, same issue, even with substitutions

sorry, for me to do that would be a violation of our company's contractual agreements with outside clients

the advisor is NOT telling me about the FASTFIRSTROW, I got an error when I ran a query

Is that because I would only see that if I were to run...

see my comments (highlighted)

What I am seeing online is the suggestion that maybe you need to make the query timeout value larger in the agent profile. This plays into...

I am able to get the est plan and actual plan via other means (query analyser, dmv's) -- before I tyr running this somewhere, what will this script provide that...

the ddl and query are attached to this post:

http://www.sqlservercentral.com/Forums/FindPost1385962.aspx

Thanks Johan

I tried the 2301 flag described in that article (option querytraceon 2301)

the actual plan it generated was WAY different from the actual without the flag, and identitifed a missing...

I'd like to get you some sample data -- what is the best way to get it to you? (BAK file [would prefer], etc.)

this is the post:

On a related note, I am trying to pass as a query hint the XML from what I believe to be the plan that the query was...

this is the post:

On a related note, I am trying to pass as a query hint the XML from what I believe to be the plan that the query was...

look at my post from 4:34:43 PM

no "divide-and-conquer", etc. until we figure out what happened that weekend

what would be the best way to get you sample data? (backup file, etc.)

anyone?

(re:)

On a related note, I am trying to pass as a query hint the XML from what I believe to be the plan that the query was using before purge

I...

I dont have time to fabricate sample data

I will see what my boss says about this and get back to you after Thanksgiving break