In Milliseconds.

TheSQLGuru (3/3/2010)

---

mansshah (3/3/2010)

---

My table has combined Primary key of (Composite key of ID and date Time). It seems SQLBULKCOPY throws exception bcs it is not checking for millisecond interval precision,...

My table has combined Primary key of (Composite key of ID and date Time). It seems SQLBULKCOPY throws exception bcs it is not checking for millisecond interval precision, it throws...

I will surely try that but what suprises me is, when i tried to use a differnt machine with same database and same setup of records insertion works perfect.

sqlbulkcopy throws Primery key violation exception, and there is no priemery key issue, I mean all are uniqure record.

All ideas are welcomed.

Thanks.

This all test that i did is to see how much performance i will get with just insert command, bcs while i ran in to this issue, I saw...

Thanks for all your Suggestions.

I have tried buffering the data and updating them in a second duration with XML datatype. It has improved throughput 3 times with single connection. I...

RBarryYoung (2/23/2010)

---

OK, thanks for the c code. It looks OK, other than the whole "one at a time" issue that you and Matt are are already talking about, because...

Thanks for quick reply. This function code is serializing all data insert from different threads.

Here is my code:

_sqlcommandInsertSP.Parameters["@fp"].Value = new Guid();

...

Thanks for such a quick reply.

Yha I see your point there but I have no choice other then inserting a single row at this time, but let me see if...

Hi,

I am facing similar issue while inserting lots of rows into the SQL server 2005 database.

My through put from the Sql server is 400 rows in a...