Thanks for the suggestions.

Some of my co-workers suggested to use EXCEPT operator and I had a faint memory of MSSQL having some kind of a hash function that would assist...

Evil Kraig F,

Thank you for your reply.

It looks like when I made a post certain special characters got removed from my post which possibly made it misleading.

From my...

PaulB,

Thank you for the suggestion.

I actually found this link, and it seemed a lot of people had similar problems: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/43c84491-66f8-4a61-bd97-54a824d56be7/

For me, all I had to do was recreate the parent...

Hi goofbauer,

I was able to accomplish my task!

Thanks again for all the suggestions.

Hi goofbauer,

Thank you for your suggestions.

Perhaps my original post was a bit confusing.

I currently have an SSIS package (let's call it SSIS 1) that reads a folder and loads...

Thanks Krishna. The tool you suggested looks interesting, but we can't wait till next month.

Has anyone tried this one: http://www.quest.com/benchmark-factory/

It seems they have free trial.

Are there any other free...

I think some of this was mentioned to some extent in the replies, but here are my two cents:

1. Subtree cost: Not sure how often people use this, but I...

That is what I assumed an intelligent system would do - thanks for the clarification!

Thanks Jim!

Steve: The move was via backup and restore. I did not get a chance to look at the resource counters. However, comparing execution plans, they are identical. ...

We just moved a replicated database from EMC to 3 Par yesterday. All we had to do was stop replication, shut down the server, copy the database files to...

Although you cannot tell what happened before, you could add triggers to those tables you want to monitor and track the updates that way.

Stops or restarts?

Yes, according to BOL (http://msdn.microsoft.com/en-us/library/aa173529(SQL.80).aspx), point in time recovery is not supported.

At the same time, the log chain is not broken, in a sense that it allows the...

Does what you said mean that I am not breaking any chain when I do that - meaning: If I do Full Backup up, then a few trans backups, then...