It's amazing how you 'uncomplicate' things. That's what I like the most about your posts.

I saw Jeff's mention that rules should be enabled only on a test server. Does...

Hi SwePeso, I will try the query out and let you know if I am able to get better performance out of it. Thanks for the reply.

- arjun

Yes, I get the point now. Sorry for acting like a dumbo. I will try it out and post the results. Thanks for being patient Drew.

- arjun

Ok drew, somehow, I don't think I can do that. I will explain the simplified logic of the query.

There are records, and records consist of fields. Each record will...

Drew, thanks for the inputs. If you check my initial post, I had also used for xml to do the concatenation. So, there isn't much difference between your query and...

Thanks Drew. I will compare the execution times and post the results.

- arjun

John, I am not reading from text files. Also, SSIS is out of the scope. This is for sort of a search engine and all data is in DB.

- arjun

hi martin, why don't you do something like this?

UPDATE [@BINMATRIX] SET U_CurrentWeight = @TOTAL,Code = OIBT.U_Bin,U_ItemCode = OIBT.ItemCode,

U_Empty = 'N',

--U_MaxWeight = OITM.U_MaxWeight,

U_BatchNumber = OIBT.IntrSerial

FROM

OIBT,[@BINMATRIX]--,OITM

WHERE

OIBT.Quantity >...

Paul White NZ (8/17/2010)

---

Guys,

In case you were wondering about this:

scott.pletcher (8/16/2010)

---

But make sure you check the plan and verify that you are actually getting minimal logging, since other things can...

Hey, thanks guys. I will run the particular query in question in both ways - insert into and select into; and go with whichever works in less time. Thanks for...

Thanks Paul. I will read it and trouble you if i have any doubt 🙂

- arjun

Hi martin, thanks for the details. I will check them and get back to you. I'm a little busy currently.

- arjun

Hey, thanks Bhuvnesh. Steve had said - "I would definitely create my indexes/PK's after the data is loaded. That way the statistics will be up to date and provide a...

Martin, I am not able to figure out what these tables are but I will try to post an answer.

Having to loop for each row is a very costly operation....

Hi Paul, it's good to hear from you. 🙂 And a great answer, thanks a lot.

Paul White NZ (8/13/2010)

---

First, you must avoid an explicit sort operation if possible. In...