Thanks for the advice.

BTW, anyone got good recommendations on what to read to get up to speed on BI/DW practices? I'd like to educate myself a but more between now...

The site name is the address. There's a "Files" tab where you specify the file.

What are the results you are looking for?

A sum will give you a count, such as

select sum( tl.pinid)

, datepart( hh, t.transactiondate) 'hour'

from transactions t

inner join...

Wow, not sure you need all the subqueries. Try converting some of those to joins.

like

update researchdaily set spfac1 = b.spfac from researchdaily

join (...) a

inner join researchdaily...

John has great suggestions, but how are you calling BCP? Is this something a person runs or is it automated?

Chris,

Valid comments and I did email Mr. Boule and did not get a response. I also emailed someone else at Quest.

Also, I received 2 or 3 email complaints about the...

Script comments have been noted as well. Thanks for those.

I think we'll do our best to avoid more ads, especially bigger ones. I think the Google ones are relatively unobtrusive,...

Actually I was hoping for people to post comments, questions, and thoughts on products. And I was hopeing to have vendors respond, post press released, etc. I hoped to minimize...

Interesting responses. I interviewed about 5 years ago with someone (I had a decade of SQL Server experience at the time) and they gave me a paper test with 15...

Why not have the forum?

A couple comments. I'm not saying I was right, but I think I did what I would have done last year or the year before.

I stated that I wasn't an...

Thank you for the comments and I stand by what I said.

Derek, if Bob had merely disclosed he worked for Quest, I would have been ok with the link....

I definitely don't think there are enough qualified DBAs already. And from the horror stories I constantly see, I'd be scared of letting most current DBAs take on a DW.

I...

OK, Red Gate has asked and bold on links is gone!

Actually Dinakar asked, but I might need James to write something for me one day

OK, quite a debate and perhaps a new record on posts to an article

I did indeed send a note to cimode and did...