Well Andy, you've enticed me into the murky world of the replicants. Actually i was heading this way anyway, but you've given me a lift and saved me time! I'm...

900,000 rows isn't generally a problem for sql server 2000.

The issues involved may include any of the following:

1) The actual hardware that SQL Server 2000 is running on. Processor...

Hi Jeremy,

Thanks for your interest.

The "Between .. and .." perform an implicit conversion on the varchar data, which bumps up the cost and is therefore done after the 'isnumeric' operation....

I've seen a few posts asking 'why' questions. After i posted the problem i realised i'd not given sufficient details and so 'edit'ed the entry. As i'm not sure...

UD3 is an indexed column and is being scanned as the first step in SQL Server's execution plan. In effect causing E2 to execute before E1.

To get around this i've...