Huh... on my machine, WHERE EXISTS ties the INNER JOIN. Guess it goes to show... "It Depends".

Don't waste your time changing that code from temp tables to permanent tables. The real problem is that it has a cursor in it that processes a wad of...

Christian Buettner (12/28/2008)

---

Conventions aid us in that they remove decision processes from us. Instead of having do decide for each statement whether a semicolon is necessary, you just use it...

feodon (12/28/2008)

---

Hello All ,

I have 2 questions from you , and I think that these are similar to each other from different aspects

At first

How can we insert a big text...

SQL Server uses BCP to do replication... that should be the answer right there. And, if you use the NATIVE mode (like replication does), you don't have to worry...

Thanks, Chris. Yeah, I know it looks unusual... WITH is the only place where a semi-colon is actually required before something and since I don't use semi-colons anywhere else...

If you don't want any of the jobs to run, just stop the agent.

Heh... of course, there's gonna be as many ideas as there are people on the forum. And, if you really want to make it simple, just put all the...

Heh... that's why I wrote the test code... I don't have to say *may* that way. 😛

I just didn't want people to walk away from this post thinking that the...

But, it's not... run the test code I made.

WHERE IN and WHERE EXISTS naturally do the equivalent of a DISTINCT and both have identical execution plans and both take the same amount of time and resources to execute...

That's a pretty good layout... I like that. Especially when you make them all have the same layout. And, although it hasn't been mentioned, there is no need...

That...

Thanks for the feedback. Just remember that order typically means nothing in a database and it theoretically could change at any time. It's always best to have a...

Thanks, Adi. Feedback like that keeps me going. 🙂