patrick.l.fornes (1/14/2014)

---

Nice article, but I do have a question regarding the conflict resolution. Microsoft states " The conflict is resolved based on the originator ID value that you specified during...

Julius Bichage (1/13/2014)

---

I have the following scenario:

1. I have live databases installed for my clients

2. I want to replicate the data from each live client into a single...

Charles Kincaid (1/13/2014)

---

Great article. I'm about to set one of these up myself. I'll hold off and anticipate the next part.

I have some tables that represent "Domain" data....

Hi Sean,

Thanks for the insightful comment. GUID space usage is by no means a sole decision point to choose PPTR over Merge. I completely agree that PPTR does...

See! You gave him the entire solution! 😀 :w00t:

What is the purpose for this project? I saw a duplicate post and responded to it, but this has the feel of a test question for school or a...

Thanks, Luis. I only saw it here. I do know that there is much more than a single join and group, but I still suspect that this is a...

Hi. This example looks like a test of some kind. I think that it is unfair to your school or potential employer to ask us to do the...

If you use SELECT INTO to create the table, and then INSERT to populate it, the SELECT INTO will copy the identity specification. SELECT INTO is not really something...

Sorry - Duplicate [snip].

ricardo_chicas (1/9/2014)

---

on a test environment I created a copy of that database, after 12 hours trying to drop the index it failed due to space on the log file, it...

Agreed; if there...

Hi... You might find some help in this article:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/819a5a05-2aed-4c88-aa26-9a07cebcfb52/convert-a-db2-timestamp-to-a-sql-server-2000-date-format-?forum=transactsql

It seems that you may be better recasting the timestamp in the select from the DB2 server, so that SSIS has an...

It seems to me that you can drop and recreate the PK / Index in question, which will free the space of the existing index and make it available for...

I am glad to see a reasonable and balanced approach to the article. Well written!

John.