Same logical names does make sense. Glad you got that sorted out.

I must be missing something here. You can't have two files on the same computer with the same name in the same directory. File systems don't work that...

Matt Cherwin (9/9/2008)

---

What GSquared said, with one addition: in the SAN environments I've worked in, two LUNs with different RAID levels will automatically be on separate spindle sets. So, even...

I found a page that might have relevant data: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1410900&SiteID=1

Try that. The post there was solved by changing the command to update the value.

Multiple logical drives gives no advantage. Splitting across phyisical drives gives you several advantages. I've tested this.

I can't duplicate the behavior you're describing with what I have for testing. Might be something specific to your data.

Are the stats up-to-date on your tables? Are the...

MrBaseball34 (9/8/2008)

---

GSquared,

Looks good except I need to filter by the o.MRN and o.DateOfService.

Also many records come over with Comments and several others have NULL Comments.

The particular DOS that I am...

SPIDs are re-used and can have different owners very easily. Might be as simple as that.

Correct me if I'm not understanding this correctly:

What you seem to be doing is moving data from a production environment to a testing environment in order to test new/modified code...

I think I need to know a bit more about what you're storing and how you're trying to retrieve it. You mentioned something about text files, but not why...

mitch (9/8/2008)

---

Many thanks guys, you've made me rethink my approach to this. My reason for having the tPerson and tChild tables seperate is that the tPersons are parents 99% of...

Reports are just XML definitions. You should be able to just add them.

Download a free trial of ApexSQL Diff, or RedGate Compare, and that will find the missing stuff and create a script that will do all of the fixing for you....

I'd move the part about validname like '%' + badname + '%' to the Join clause, but otherwise it looks fine.

I created a 100-thousand row copy of your table and...

First, why a Full Outer Join? I'd make it a left join. That won't affect your issue, but it will improve performance.

Second, why a cursor? Why not...