|
|
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
Navigation:
[Reply to this message]
|