I don't know the answer for your question. Sorry for that.

Why do you expect bak file size be equal to size of primary data file?

Are you sure that at the time when you run update stored procedure your SqlDataReader is already closed? Can you prove it?

dwilliscp (9/7/2012)

---

To write new data using three outer joins or to use one outer join, and get most of the data, then use three updates to load the other three...

Luis Cazares (9/5/2012)

---

Was that sarcasm? I really hope so, otherwise you...

There are more tables in the query than those 3.

To be able to re-create the issue these tables are needed as well:

[DBXN].StreetNumberSuffixLookup

[DBXN].StreetTypeLookup

[DBXN].StreetDirectionLookup

[DBXN].RouteServiceTypeLookup

[DBXN].DeliveryInstallationTypeLookup

[DBXN].CountryLookup

[DBXN].ProvinceLookup

Kenneth.Fisher (8/30/2012)

---

Just a guess but you might consider looking at your indexes. You probably have an index that covers CE.ID, CA.CustomerID and CA.PostalCode but doesn't include CA.EnglishAddressLine1.

I...

Since it's a website response time, have you already eliminated the possibility of the issues with web app or network latency between the service and the website?

Please post plans for both of the queries.

Click here

From vendors of the products you've mentioned.

Do you expect us to know what Scribe package is and how to run it?

Certifications from vendors

pooyan_pdm (8/8/2012)

---

What I said is a general guidline and is true, yes with a ever increasing key the inserts does not cause the fragmentation but generally speaking beacuse most of...

You can try

DBCC FREEPROCCACHE