Jeff Moden (11/18/2012)

---

CELKO (11/18/2012)

---

When I teach kids who grew up with HTML, XML, etc, they immediately see the (lft, rgt) pairs as tags and have no trouble at all.

Here...

I would say yes, this is quite possible. Take a look at PowerShell. I am assuming that even if the files may change the directories where they reside...

Another FYI. I haven't used maintenance plans in years to maintain my indexes or satistics. I developed my own processes using T-SQL to manage these in a more...

jgenovese (11/17/2012)

---

the stats which were rebuilt were COLUMN statistics

I thought table index rebuild only updated TABLE statistics (fullscan)

Are you trying to tell me that this is not the case, i.e....

Love being told by an OP that the execution plan they posted was an ACTUAL execution plan when it is obviously an estimated execution plan. Really, was I born...

jgenovese (11/17/2012)

---

A new development:

As previously stated, the "trans" and "asset" tables are subscribed tables

I re-initialized the subscription this morning

Now the query appears to be back to normal run time

(no changes...

jgenovese (11/17/2012)

---

"One other thing would really help, the actual execution plan."

This IS the ACTUAL execution plan

"Also, do you really drop the temporary table as soon as it is populated as...

Also, no one is really going to dive into what you recently posted in an effort to help you figure out what be going on. We really need the...

Just an FYI, your parse routing is slow. Take a look at this one, then read the article and its discussion that is referenced in the comments.

Be sure to...

jgenovese (11/17/2012)

---

I believe it is multi-line

Note that the query did not change -- the emphasis is on what could have happened that weekend that caused the query to double in...

Taking a guess here, but is the table valued function you use in this process a multi-statement table valued function?

Also, looks like you may have several scalar functions being used,...

I have to agree with Jeff at this point. I have looked at the estimated execution plan, but one of the things we really need is the actual execution...

After completing the index rebuild, did you then rebuild all the statistics? If so did you use a sample size or full scan?

If you used a sample size on...

I think I have a good QB off waviers. We'll see how things go this weekend.

SequelSurfer (11/14/2012)

---

Lynn Pettis (11/13/2012)

---

Missing the real point, he has a bye week this week and my backup has a concussion. However, it would be nice if he would at...