Your requirement sounds weird. On the first instance why do u want to modify the CustomerAddressID i.e Primary Key value and that too and Identity column. Whenever the customer...

The data in the individual tables are already of high volume and combining those into a single table would again hit performance. It does require partitioning of the data....

The purpose of Register / Connect are the same, the only advantage of Registering over Connect is that You can replace the registered server name with a new name and...