Please refrain from cross posting so it is easier for everyone to follow along. See response here

http://www.sqlservercentral.com/Forums/Topic418746-147-1.aspx#bm418759

Without knowing more about your process and the query behind the report I really cannot say why it is slow. Looks at your query design, how toy apply your filters...

Might be a cahcing issue. Try running the item to completion once and if takes 45 seconds rerun to see if it returns quicker the second time. Then wait about...

Thinking about that I would do something like this

SELECT

....

FROM

dbo.Audit_Data AD

INNER JOIN

dbo.NIC N

ON

AD.NIC_VALUE LIKE '%' + N.NIC_DESC + '%'

This assumes your NIC DESC will not need any special circumstance where the...

Lot's of ways to do this sort of thing so you have to kind of break down your concepts of what you are addressing.

For example you know that you ultimately...

Because of the types of joins involved it will not affect your resultset in any manner. Had this been LEFT or RIGHT joins it would. But for readability and better...

Just be aware the table must have data in it to produce an output...

Look at the schema information view

SELECT * FROM information_schema.columns

should help you get what you are after.

Sorry no there is not in 2000.

Thinking about this it sounds like the date may be -1 (12/31/1899) is being inserted and not null which the date is valid so it passes the rudimentary check. Might...

How are you displaying the data to see that value?

Try this way

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim strDate as string

strDate = (Row.PRBEGINMO1 & "/" & Row.PRBEGINDA1 & "/" & Row.PRBEGINYR1)

If IsDate(strDate) Then

Row.BeginDate = CDate(strDate)

End If

End Sub

Matt Miller (10/29/2007)

---

For what it's worth - according to several MS case studies - the best performance during a big ETL load like that is achieved when all indexes EXCEPT...

Oh btw it is common for folks to do data loads by dropping indexes first which I got the impression was a fully reload. However, if I am wrong you...

With such a significant database size the amount of data movement has to be very large and the recreating of the indexes will be very resource intensive. With on 2...