When you get the multiple records, do the values for the columns at the end of your query (f.depend_lname, f.depend_fname, f.depend_dob, f.depend_relat) change for each row? It sounds like...

Are there any odd characters in the string? Maybe a carriage return at the front? Do you get any errors returned? What are you using to determine...

Thanks GSquared. It looks like the margin of error. I got exactly the same number of pages in all 3 indexes, but the second had one more fragment...

I don't think that would make too much of a difference. At the leaf level the index is either storing a pointer to the page containing the rows data...

I'm starting to shoot a little wildly here, but do a distinct count on the columns for both indexes. It sounds like the fast index is composed of two...

The only other thing I can think of is some kind of corruption, but it would have to be so specific that I doubt that would be it. I...

You're right. I didn't think about EM scripting out the owner as well. If Chirag's idea about the database isn't right (maybe due to some kind of caching?),...

So... the first index has two kinds of fragmentation. 1st - some of the pages and/or extents are out of order, 2nd- not all the pages are full of...

There are two pieces here - one is the selection criteria and the other is the age computation.

The selection criteria is wrong I think: If you do not want...

Or maybe a view on the Oracle end?

Chad

Just a shot in the dark here, since no one has replied to you yet... Check out sys.dm_db_index_physical_stats using the DETAILED scanning mode and see if the fragmentation, or page...

Could it have been owned by a different user? Maybe it was originally created by userA, so it was named userA.myproc, and when userB went to execute it, it...

I don't know what is wrong, but maybe you could narrow it down by commenting out groups of columns until you get a set that works. My guess would...

mmmmm.... Dinner Join.... sounds like an invitation to a barbeque.

Reminds me of the QOD from 12/13/07 that used a MIDDLE JOIN. 🙂

Chad

It isn't standard for linked servers because you can get the metadata from some. I really don't know what makes the difference - there may be some way to...