runal_jagtap (9/24/2012)

---

Hello Everyone 🙂

Finally i have been assigned this task to do next month..

but they are still not sure that if i Change the Log File location of the database...

Sorry, that was a mess. I fixed it up.

Lynn Pettis (9/13/2012)

---

And yet in practice, I have found that breaking things down and using temp tables instead of try to do everything in one query can in fact be...

Eugene Elutin (9/13/2012)

---

Who gave you such impression or where did you take it from?

Quite often splitting tasks using temp tables will not only significantly boost performance of complicated processes,...

Perry Whittle (9/12/2012)

---

You're mixing dissimilar I\O patterns on the same physical array, they should be separated for maximum performance. 2 logical drives on the same array will have I\O pattern...

Eugene Elutin (9/13/2012)

---

Can you try this:

SELECT column1,'99' [a],left(column2,2) , max(column3) [c], 'Yes' [d], 'Test' [e]

,ltrim(rtrim(column1))+ltrim(rtrim(left(column2,2))) as test

INTO #pre1 ...

Lynn Pettis (9/13/2012)

---

What would really help us help you is if you would provide the DDL (CREATE TABLE statement) for the tables involved including the indexes currently defined on the...

Well I did some more digging and it looks like the ltrim/rtrim is doing something because I get different results if I take them out. From what I gathered...

Jeff Moden (9/12/2012)

---

Have you tried the NOT IN without the DISTINCT?

Also, what's with all the LTRIM/RTRIM stuff? Data should be properly stored without leading spaces and trailing spaces hardly...

Thanks everyone. I learned a lot here. I went with the NOT EXISTS and it finishes in 2 seconds now. Very nice!