Hi Steve,
Steve Eckhart (9/30/2010)
Actually, if you read carefully, an index on a computed column CAN include multiple rows and columns from other tables.
Can you give an example of multiple rows? I doubt it.
And for the columns from other tables -> That is per definition non-deterministic.
http://msdn.microsoft.com/en-us/library/aa214775(SQL.80).aspx
As long as one of the following four conditions are true, then you can use the computed column in an index.
Now that does not say "exactly" one, it means one or more. It does not tell you which combinations would be deterministic and precise.
Best Regards,
Chris Büttner