Table 1

Record ID

hash to speed searching

concatenated integers for full comparison

other CRUD stamps...

OK, missed that on the first and second read of the article. My bad. the approach I have used in the past does not maintain RI, but your second table...

You can create a package that performs a single table create/load/process and use variables to override table name, file name, etc. Nest the for mentioned package that has the loop...

Does order of names matter?

I will post this to my blog with more descriptions, but here is some test code. We use this style when users have the ability to upload, make minor revisions,...

Have you tried working with the SqlBulkCopy objects in .Net? I use them with OLEDB connections and they are very for large data sets.

A second approach is to use a...

Does the CLR handle the where clause properly or does it always return all sub-values?

We highly recommend that developers seek other alternatives first. Many of the uses cases for CLR have been replaced by new functionality in the database engine, such as compression, encryption,...

“The maximum amount of data that can be lost in the case of a disaster”

This statement may need a bit of an update, or an clause that assumes your only...

In my junior years, I was more willing to simply follow the orders from upper management and collect my paycheck at the end the of day. Getting called on nights...

Many smaller businesses will find a better price point outsourcing their back office solution to the cloud. They can reduce, if not completely eliminate all onsite IT since most users...

I have not found any broadcast mechanisms in SSIS. We have packages that deploy the same data to multiple servers by running the same package but overriding the connection string...

I cannot imagine our world if Codd had a patent on 3rd normal form and blocked others from creating the modern database engine.

did you update statistics on both servers?

Yes, check this one

http://www.sqlservercentral.com/Forums/Topic1535981-149-1.aspx#bm1535983