None of this would be a problem if you first inserted the data into a staging table and validated it.

bcronce (8/28/2008)

---

kind of off topic but when you said

are time stamps guaranteed unique or 'just as long as you don't...

"Oh, oh, oh! More Power!"

Check out the "AverageRecordSize" in the return of the following...

DBCC UPDATEUSAGE (0)

DBCC SHOWCONTIG WITH TABLERESULTS

j mangual (9/3/2008)

---

Seems that the rebuild of the indexes can't lower the AVGFragPercent less than 80% for some of the indexes and 50% for others? Nor can it lower the...

Check out the column called "AverageRecordSize" in the following...

DBCC UPDATEUSAGE (0)

DBCC SHOWCONTIG WITH TABLERESULTS

I seen many, many people get burned by importing data directly to the final table. It would be much better to import it to a staging table and validate...

I gotta ask... why do you need to do this? What is the purpose of this?

Heh... understood... I think they call that "agile" programming and I hate it. 🙂

You said in your previous post that ID's 1-6 were singleton's... looking at the data you provided,...

TheSQLGuru (9/3/2008)

---

Jeff Moden (9/2/2008)

---

No, I sure haven't... my apologies. Have a new job...

You're right, Chris... my bad. I lost track of the basis of this thread. Thanks for the feedback.

Ray Mond (9/3/2008)

---

You could also check the growth rate that's set for your data and log files. If it's too small (e.g. in 10 MB increments), the insert will...

GilaMonster (9/3/2008)

---

It shouldn't contribute to the logical fragmentation. That's...

olafdedig (9/3/2008)

---

SOLUTION:

Hello, Here is the solution I found to my problem:

For doing a task like sending html mail (built using a SQL script and a Script Task) the for...

Ummm... I'm not very smart about SSIS because I don't use it... I always use something else like BCP, etc.

That, not withstanding, I follow the logic of the flow you've...