Posted by Erland Sommarskog on 01/27/06 00:19

MC (marko_culo#@#yahoo#.#com#) writes:
> Thank you for that, I assumed engine would 'optimize' that and never
> checked. Just when I think I actually know something ;).....

As I mentioned, it does optimize when the server is @@servername, which
it can recognize. But it does not analyse connection strings.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Query out an xml element from a field containing xml data
• Prev in forum: Re: select cast help needed
• Thread view: Re: Joining tables in different databases

[Reply to this message]