I'm probably exposing my ignorance here but with a view on just one table is there any difference between having an index on the view and having an index on...

L' Eomot Inversé (1/3/2012)

---

Well, that shows as much cultural bias (but towards one culture of...

kaspencer (12/23/2011)

---

I have complained before about the fact that many of your non-SQLserver questions are far too centred on the American and assumes that everyone is American and lives...

What he said.

Making it obvious what's going where is, IMHO, really important. Similarly, I try hard to avoid scrolling past 80 characters (as that seems to be a default...

It's becoming more a game of 'what point is the questioner really trying to make' than actually looking at the code and working out the answer. Maybe everyone could...

Why didn't I think of that? Thank you very much.

I'm not convinced that EXPRESSION is not executed

Try this:

SELECT 'TEST'

WHERE EXISTS (SELECT 1/0 WHERE 1/0 =1)

The quote I've heard is "it's better to have 100% of a Mini [used to be a small, down-market UK car] than 90% of a Rolls Royce [hope you all...