ChrisM@Work (9/29/2015)

Wayne West (9/29/2015)

We now have Unicode URLs, so why not Unicode characters for email addresses. You can Google Unicode...

Re the 10 Mill addresses and the stats.

To be blunt I generated random character strings for the addresses (there as an @ in the middle), so they hardly represent a...

Well partly because the OP was doing so, and partly I assume that it is possible that some languages might need it.

Interesting - I have tried a little - rough - test.

CREATE TABLE [dbo].[TestEmail](

[Id] [int] IDENTITY(1,1) NOT NULL,

[nvarchar](200) NOT NULL,

[chk] [int] NOT NULL,

CONSTRAINT [PK_TestEmail] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH...

There appears to be quite a misunderstanding of how an index seek works - on character data. Characters are compared position by position, as soon as one differs, then the...

Wouldn't an inner join work just as well, and inner joins are a bit more efficent than outers.

LOL perhaps forget that proposal.

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the WHERE clause,...