Posted by Erland Sommarskog on 10/31/05 01:38

Neil (nospam@nospam.net) writes:
> SELECT INVTRY.*, InvtrySelections.Sel, InvtrySelections.MachName
> FROM dbo.INVTRY INNER JOIN
> dbo.InvtrySelections ON
> dbo.INVTRY.ID = dbo.InvtrySelections.ID
> WHERE (dbo.InvtrySelections.MachName = HOST_NAME())

Now that I see the entire view, I repeat what I said before: make
MachName nvarchar, and put the clustered index on this column.


--
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

• Next in forum: question about log file size when alter Huge table
• Prev in forum: Re: Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
• Thread view: Re: Problem with HOST_NAME Function with Linked View

[Reply to this message]