Have you tried checksum? First you need a unique or primary key. Then calculate a checksum for each row based upon the selected column list for each primary key (or...

You can BCP out views, and BCP out using query with the QUERYOUT option. You can do quite a few things with BCP with a combination of views, functions, queries, etc...

A third option is using OPENDATASOURCE or OPENROWSET.

I decide on what constitutes a database based upon data integrity and disaster recovery. Generally a database should contain those elements that need to be managed together to maintain data...

We have changed our loading strategy over time, and depending upon the situation and changing business requirements. As our company becomes more dependent upon our data warehouses and the warehouse tables are becoming...

We've done this by using a 'data checking' table. The data rows which are candidates are put into the working 'data checking' table which has been declared the VARCHAR columns....

I like the CHECKSUM processing for simply identifying rows that have changed with good performance.

Another solution I have used in the past is to Bulk-copy out the two tables using...

For minimul logging you could BCP out the data using a view which would put the date on most of the records and then BCP the data back in.

In the past I've had to defrag tables on a server where there was not enough room on the disk to expand the database to a size which would allow...

One technique I've used is to create a view which selects the rows you wish to keep, BCP out using the view, truncate the table, drop the indexes, BCP in...

We actually do this all the time. We have created a generic DOS Bat job which take parameters (server names, database names, etc.) to perform the action. We perfer the...

I typically use a date diimension when I build data warehouses. Performance is a big reason for this. Your query requires the scanning of a large number of index entries...

Our calendar table has a generated key as the primary key. The records in our data warehouse then contain the date key that corresponds to the date. The rest of...

I have also done this with a BCP by BCPing out the rows I wish to keep using a view or a select statement, truncating the table, and then BCPing...

You could use a view to order the columns however you want.