kinderdesign (9/23/2011)

---

OK.... I've never done this before, so I'm not sure how to test it. I tried running it as a Query from Visual Studio 2008 and get errors....

Sean Lange (9/26/2011)

---

SwayneBell (9/26/2011)

---

L' Eomot Inversé (9/24/2011)

---

What gave you the impression that Craig thought addresses belonged to only one person?...

Burninator (9/23/2011)

---

I’m gonna go out on a limb here and disagree with all y’all. I work with address data extensively. I ceased to believe years ago that “we’ll...

Mike C (9/23/2011)

---

Ahhh, my point is that the tail isn't always the best drop point. In the application I tuned not long ago the tail was the drop point (identity...

Mike C (9/23/2011)

---

I'm surprised you're mixing and matching varchar and nvarchar data types. Normally you'd see one or the other in a table. That's a nitpicky thing, but can cause...

Addendum on a second look:

[hashField] AS ([dbo].[getMd5Hash]([entryId])),

As a calculated column, non-persisted?

This table is just RIPE for pain.

Mike C (9/23/2011)

---

Based on the OP's description it sounds like he's checking to see if the record exists first. Possibly via SELECT prior to INSERT.

So here's a question: assume a...

A little easier to read the definition like so: (EDIT: I see you fixed it in your original post)

SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO...

Mike C (9/23/2011)

---

Evil Kraig F (9/23/2011)

---

You'll want to make sure your clustered index is controlled to try to append to the tail at almost all times. There's some other...

Kinder, I think I'm understanding what you're trying to do, but not well enough.

Can you provide table DDL and sample data? You'll see what we're looking for in the...

100's per second isn't a significant issue, usually, but it will depend on hardware and setup.

You'll want to make sure your clustered index is controlled to try to append to...

Open Rowset? What are you loading this from?

What are your options in this drop...

Yes. Yes. Yes.

This is a case where normalization is inappropriate. An address should belong to a particular individual, so you can change that person's atomic data appropriately without affecting...

I'll third that the state by state discussion really isn't apt anymore, except in some rural areas. It's more jokes then actual hard feelings anymore.

The one thing I did...

The wizard is using SSIS, but probably with different destination options.

Go to the destination and make sure data access mode is Table or View - fast load. Set maximum...