anyone help me with the said question, thanks so much!

SSIS is fairly rigid in how it works, so you have to be wary of DDL/Schema drift.

You can easily create a SSIS package which will copy ServerA TableA...

What do you mean by "Dynamically" here? You can define the sources/destinations with expressions, yes, but the data flow part of SSIS has to be well defined so...

EXCEPT  is great.   But to be clear, it doesn't require that the tables have identical structures, it compares the results of two queries.    You can select a...

thank you Jeff Moden!

I want to the theory of checksum while using it as comparison condition.

For the above to work, TableName1 and TableName2 would need to have have the same structure.

Since the structure is the same, why not use

SELECT *...

Another thing is, what is the allowable latency for the data?  Does it actually have to be up-to-the-second accurate or is it something that you can download once overnight...

One aspect of remote queries you can't affect is the data being moved between the two systems. If you move one million rows (just plucking a number out of...

Remote scan usually means copying the remote table to local memory (tempdb) in its entirety and then scan it locally.

If the same object is scanned repeatedly it might make...

There isn't really much that you can do.

Are you accessing the data with OPENQUERY ( you might pass some query hints) ?

Check the linked server provider options

Is it possible...

You can only upgrade 2 versions.   So, 2005 you can do an in-place upgrade to 2008 or 2008 R2.

BUT, guess what.  2008 and 2008 r2 are also no longer...

What OS is being used - is it x86 or x64 OS?  Since this is SQL Server 2005 - I suspect you might have an older x86 OS.  If...

SQL Server, by default after an install, will attempt to use every bit of CPU and RAM that the system will let it have. Assuming you've changed none of...

thanks !

I know use 'schemaname.tablename' , then it works fine, thanks!

need to use quotation mark.

sorry , the said picture should be like this one, thanks!