What?? In his example, the relationship persists because the RowID is maintained between the two. With the example shown, you can re-link the Names and Addresses by running...

Thanks. Your example is different that what I thought you were after. I was thinking that you wanted to split the data differently as in 1/2 of the...

OK, we're getting there. Now, what would you like TableB and TableC to look like based off of the sample data you've provided for tableA?

TableB

????

TableC

????

What you are asking for does not make sense. If you are going to put half of TableA's rows into TableB and half into TableC, what is with TableB's...

Did you read the link? What I want is in my post. I want you to mock up an example that we can work with. Help us...

John is right. If you are going to scale your original query out to gather data from multiple tables as such, a UNION is probably the best way to...

This sounds pretty simple, but you'll need to provide more information to get good help on this one. How about some table DDL and sample data. Better yet,...

I'm not sure I fully understand what you are after here, but here's a go using Kent's sample data:

SELECT f1.*

FROM @Fruit f1

LEFT JOIN...

Yes, use derived tables. It's hard to give you a good example without knowing more of your situation. If you need more help, post more info. on your...

This sounds pretty simple, but you'll need to provide more information to get good help on this one. How about some table DDL and sample data. Better yet,...

An average disk queue length of 50-60 tells me that you have an I/O bottleneck. The danger of using a SAN for DB storage is that the storage admins...

This may help: http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/. I've implemented a variation of this and it has been working for about 1 year with very little intervention/maintenance.

Thanks for the follow up. Glad to hear you've figured it out. Check to make sure that the autoshrink property is not enabled.

Check your exectution plan on this one and watch your indexes. Using LIKE with a leading wildcard will result in a table scan if you're not careful. From...

I hope that helps, but like John M. said, your description is a bit confusing so my reply was kind of a stab in the dark at what you wanted....