Voitek (1/29/2010)

---

I prefer to use dynamic SQL, and that has always resulted in good performance. However, in this application I chose to encapsulate the query into a stored procedure for...

I will add to the thread that there are MANY cases where you can have widely varying inputs and dynamic sql is by far the best approach to ensure optimal...

lmeinke (1/28/2010)

---

Hello All,

I've solved the problem using access as a "pre-import" tool. My question is "Why should I have to do this?"

I could not pinpoint the error in SQL...

>>Do you have a suggestion on migrating to something else? Such as a sequential integer or something like that? What is more popular?

Deciding on an indexing strategy is certainly...

kingscriber (1/28/2010)

---

TheSQLGuru (1/28/2010)

---

We cannot really help you without lots more information, and true help may be beyond the scope of forum postings/responses.

However, I can say unequivocally that GUIDs...

XML may prevent the use of parallelism by the query engine, just like scalar UDFs and other operators do.

We cannot really help you without lots more information, and true help may be beyond the scope of forum postings/responses.

However, I can say unequivocally that GUIDs are HORRIBLE...

Boy I like that! I hope it works - I will add it to my script repository.

Autoupdate stats will NOT help you here if you put only 1 to 10 M rows into a table with 100M rows. Takes 20%+ to trigger the stats update....

There are many things wrong with this trigger:

1) as others have mentioned it doesn't handle more than 1 row. You say ordernr is unique - so what. How...

One thing I will add. If you have values (such as the GUIDs) from previous inserted data that you do in a set-based statement that you need to use...

Tom, it wasn't your post(s). Talltop and I had a spat.

I understand -...

removed by poster to keep thread from getting locked

1) take Jason's recommendation but modify to use newer fileIO stall DMV in 2005 that replaces fn_virtualfilestats. Better granularity data. Also modify to have user-configurable input for delay...