For the cross join (and cross apply).

Without the index on testdata table, I got 2000 ms and 50000 reads.

With the index, I got 50 ms and 1000 reads.

Jason, would you mind run the tests again with this index for testdata table?

CREATE UNIQUE NONCLUSTERED INDEX [ixu_testdata_ndex_incl_tenpower_twodigit] ON [dbo].[testData]

(

[nDex] ASC

)

INCLUDE ( [tenPower], twodigit )

and use this index with...

Try to use CASE SENSITIVE COLLATION.

SELECTLTRIM(STUFF(RIGHT(CONVERT(VARCHAR(26), CURRENT_TIMESTAMP, 109), 14), 9, 4, ''))

Also, how can you tell if a certain day was holiday or weekend?

What increase in payments can you expect for certain type of overtime?

Please post a complete set of business...

This statement is not even inserting into the table where the trigger displayed above is.

See http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server

Great job, Matt!

There is even a Microsoft Knowledgebase Article for this

http://support.microsoft.com/kb/291332

The thing is that only Expiration and eMail columns are used in the query so the ix_temp index could be considered a covering index, right?

If all calculations are made upon 'Metro', move the filter to the WHERE clause.SELECTDATEADD(DAY, ToC, '19000101') AS TimeOfCode,

Total416,

TotalAttempted416,

TotalAttempted416 / Total416 AS PercentAttempted416,

TotalContacted416,

TotalContacted416 / Total416 AS PercentContacted416

FROM(

SELECTDATEDIFF(DAY, '19000101', TimeOfCode) AS ToC,

COUNT(*)...

CREATE TABLE#Temp

(

eMail CHAR(36),

Expiration DATETIME

)

INSERT#Temp

SELECTTOP 1000

NEWID(),

29000 + ABS(CHECKSUM(NEWID())) % 20000

FROMmaster..syscolumns

CREATE INDEX IX_Temp ON #Temp (Expiration, eMail)

-- Peso

SELECTEmail,

'Active' as Type

FROM#Temp

WHEREExpiration > '1/1/07'

UNION ALL

SELECTEmail,

'Expired' as Type

FROM#Temp

WHEREExpiration < '1/1/07'

-- Jason

SELECTeMail,

CASE

WHEN Expiration >...

I didn't see your suggestion when posting.

But it can make a difference depending on which indexes that are present.

Use "UNION ALL" or "UNION".