Prev: PAGEIOLATCH is a lead blocker
Next: open MDF file without MSDE
From: Erland Sommarskog on 26 Jan 2006 17: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(a)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
First  |  Prev  | 
Pages: 1 2 3
Prev: PAGEIOLATCH is a lead blocker
Next: open MDF file without MSDE