Solved my problem. Turns out the two tables weren't 100% structurally the same. One of...

^%&*^$*^%$*&%(&^%&

I figured out it! There is a d*** trigger on the Published table. And guess what, it has embedded while loops.

Thanks for looking!

I will disable the trigger, run...

L' Eomot Inversé (9/7/2013)

---

Not sure what one row at a time means (or indeed what the relevance of a batch is) here; the specification of T-SQL makes it quite clear...

If I read your original post correctly, meaning that you are...

ananda.murugesan (9/7/2013)

---

Hi,

Principal server unexpected shutdown and also not available Primary database , in that situation secondary server MIRROR database should be bring online mode for user access as well...

I have a weird situation here.

Any thoughts or suggestions would be welcome.

When I drafted my QB I had a choice Brady or P. Manning. Did I make the right choice??

You're killing me and none of my players have even played...

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual job....

ScottPletcher (9/3/2013)

---

You don't want to use a function against the END_DATETIME column if you can avoid it, since any function will prevent SQL from using the full seek capabilities against...

LightVader (9/3/2013)

---

Lynn Pettis (8/31/2013)

---

The problem as I see it, especially at the high school level, is the girls don't want to be perceived as nerds or geeks. Trust me,...

T.Ashish (9/3/2013)

---

Chris,

I split the OR condition of query in two parts and combined results of both queries with UNION ALL. New query is 50% faster. I have attached new plan...

Would it be possible for you to post your code?

I alternated between last and first each round. Every time I drafted a player I would do 2 in a row except the last round.

Sort of wish after 1st...

I think there were 5 of us. I probably shouldn't have participated. I may have screwed my chance for a three-peat.