There are not two different tables. The query points to ServerB whether it is ran on ServerA or ServerB. Also, there is no NULL values in the sub-select.

I originally thought about making Listings.CompanyID aclustered index and Listings.ID a unique nonclustered primary key. However, it would not let me partition the unique nonclustered primary key. Additionally,...

No, I haven't tried using multiple CTE's yet. Might be worth looking into.

Right, it is a varchar. I don't understand how commenting that line out would cause it to execute successfully.

Yes, the very same HouseNumber. The funny thing is is if I comment out the part that says "AND StreetName = '175TH'" it seems to work. Obviosuly not...

I changed the cast from int to float to allow for values such as '1e4' and changed it to use a CTE and I still manage to get the same...

Sorry for the confusion. I misunderstood your post. I thought you wanted me to execute the two separately. I will take a look at the code behind...

Is the index size contained anywhere in a table or view that I can join to the query?

I took my training through a company called Global Knowledge out of Raleigh, NC. I would definitely recommend the instructor I had named Tracy Wallace. I was more...

Trace flag 1206 is used in conjunction with 1204. It displays all locks held by both deadlock parties. Thanks for the 1222. I have enabled it now.

I have figured out what was going on. I did not set trace flag 3604 to display the results of DBCC Page to the current connection. Thanks.

Thank you Jackimo. Worked perfectly.

I knew someone would be quick to jump on that. I did not cross post. I created the post in the wrong forum so created a new one...

GilaMonster (1/22/2009)

---

You can always combine include columns without an effect

You can usually combine the inequalities without breaking anything, not always

You usually can't combine equality columns without causing a problem.

I blogged...

Thank you. I have been combining thinking it would be ok. I just didn't know if I was going to cause a query not to use the index...