Posted by Erland Sommarskog on 11/01/05 01:02

Neil (nospam@nospam.net) writes:
> After I got your note I did go ahead and make MachName nchar, as BOL
> says that HOST_NAME() returns that type, and the sample it showed of
> storing its return value in a table used an nchar(30) field.
>
> The InvtrySelections table had the PK (ID/MachName) as the clustered
> index. I created a second index on MachName alone, and it made it the
> clustered index.
>
> With the above two changes, the results were the same. Still getting
> "#Deleted".

As I said, I did not really expect that. I more had performance in mind.

But now it occurred to me, that it's a bit of a non-issue for you. To
wit, the rules for implicit conversion are different in SQL 7 and
SQL 2000. The potential performance problem I saw, probably only exists
in SQL 2000. Then again, it's good to be prepared, in case you upgrade
to SQL 2005 one day. :-)

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]