Look, I wasn't there, and likely won't ever know what you were really up against, so I won't argue this point with you anymore. I am well aware of multiple...

mohammed_suhan (3/30/2012)

---

Hi,

Thanks alot for the suggestions.

The table already had identity column, SSIS inserts the data to this table every week. but it was not following the sequence which...

He may not have believed you because you only gave him a partial solution. As the OP explained they had experienced, after only adding an identity column to the table...

Z1024 (3/30/2012)

---

opc.three (3/30/2012)

---

Z1024 (3/29/2012)

---

For tables with millions of rows you should really be careful with indexes, It can take literally hours (on commodity hardware) to delete say 10k rows from...

Said what?

capn.hector (3/30/2012)

---

PaulB-TheOneAndOnly (3/30/2012)

---

opc.three (3/30/2012)

---

The only way to ensure the data is not scrambled when inserting into a table is to reduce the "bacth commit size" to 1. Whether bcp, SSIS...

Jeff Moden (3/30/2012)

---

As a side bar, it's always amazed me that people find importance in the order of the data in a file without actually having something in the file...

Matt Miller (#4) (3/30/2012)

---

Lynn Pettis (3/29/2012)

---

And then when you select from the table be sure to use an...

Very common in an adjacency list.

Probably not a batch process...more likely copy/paste. You can copy Data Flow tasks, and then paste them back to the same Control Flow surface to gain a complete copy. If...

Dash is not supported character in object names, without escaping, so if it is dbo then try it like this

dbo.[member-update]

It could be a lot of things, but it sounds like parameter sniffing, i.e. a bad execution plan.

Have you tried comparing the actual execution plans from the query causing trouble...

To answer this too, yes, you can change the max memory without rebooting. However, a reboot...

sqlfriends (3/30/2012)

---

Thank you, sorry it is kind of hard to understand the memory configuration.

But from what paul.knibbs said to set to max 2.5 GB, but opc.three said to set it...

capn.hector (3/30/2012)

---

here in my shop we have a history table that we have no PK on. we just have FK's to the pertinent data and just insert to it.

since...