doh - double post

Saurabh Dwivedy (1/27/2010)

---

Kelsey Thornton (1/27/2010)

---

CirquedeSQLeil (1/26/2010)

---

if one examines execution plans for these two queries and run them together, the query optimizer treats them as the same execution plan and equates...

Thanks for comparing the window function to the subquery. Nice article.

Some of what factors into the performance and which column to list first comes from the query and how it is written. Could you provide the query and the...

tennis

Now that's a datacenter.

These comics are great.

Just running through the items in that post:

1. unlodctr/lodctr was unsuccessful? There was a link to a microsoft article on the subject.

2. Is remote registry service running?

3....

honza.mf (1/27/2010)

---

I answered OK, but...

The first variant with IN can be more effective, it allways depend on data. Compare two queries without any knowledge about structure of tables, indexes, possible...

That's what I understand to be the current issue as well. Do you have any other ideas to run that script than to break it out into multiple scripts?

vstitte (1/26/2010)

---

Thats what Jason is asking.

Do you want the date column in the result set? If yes, what do you want the output to look like?

If you exclude id and...

And how would you like the date column handled? The date column does not really go well with your proposed output and requirements. Which date should one use...

I registered at SSC many moons ago. I didn't truly start participating (not even lurking) at SSC until July of 2009. Then I got real busy again and...

Based on your provided reference, I would agree. However, if one examines execution plans for these two queries and run them together, the query optimizer treats them as the...

Good article. I couldn't add anything more than what Paul has already indicated. Maybe a follow-up article on the same subject to go along with that QOD?;-)

Please provide sample data and what the desired output should look like. This will facilitate the process in helping you get a correct answer.