I am confused I had seen a rather long query in SQL profiler its all on one line and I ran it to capture the query plan.
For readability I added some line breaks and executed it again.. and the query plan had totally changed to a far more efficient plan.
I thought I was mad so I went back and tried it again and again.. and every time the query plan was different when line breaks where introduced.
I have no idea why this is happening? Any ideas?