We could have done that, in fact we've done just that in the past when they didn't tell us for a few days. The DB in question is larger than...

Very promising! I was able to get the query down from 1:51 for 4100 rows every time to under 15 seconds for the same data on first run (much faster...

OK, I think I just had a thought. Right now I'm using this as a function, which means for every row it's going through the unpivot process for that year...

You may need to edit your stored procedure. I set that up and it sent me an email for the one database that had more than 80% free. This should...

Do you know if there is a Java plugin for SSRS? I know there is one currently for Crystal, but as our company migrates from COBOL to Java, we are...

Sure enough there are only 4 pages in this index. I'm not sure why it wouldn't re-order them, seems like if you were going to re-organize an index you would...

I'll just add a step to the scheduled job to truncate the log then. I'll do an initial shrink file, but I don't want to do that regularly, because if...

Yeah, I like that better than the way I was doing it. Thanks!

SELECT 'Company A', 'Web', '01/01/2006' UNION ALL

SELECT 'Company B', 'Tradeshow', '10/03/05' UNION ALL

SELECT 'Company B', 'Magazine', '12/05/04' UNION ALL

SELECT 'Company C', 'Company A', '09/05/06' UNION ALL

SELECT 'Company C', 'Web', '12/07/07'

Would...

Never mind... mark gave me a good solution using CTE and row_number() but I forgot this was on a 2000 box and not a 2005. I posted this in the...

Thanks Mark, that worked great on my test box... then I forgot we are still running this on SQL Server 2000, so the cte and row_number function wasn't available yet....

Thanks Guys, I'll give the Transcendors a shot too. I picked up the self paced kit with all three books for $150 after taxes, so that seemed like a better...

After continuing to read through other threads it sounds like a lot of people recommend the MCTS self paced kits for those tests.

Any other sources would still be appreciated,...

Just for kicks, I created the package on a different sql server on the network. Had it point at the share I created, and it ran successfully. So I scheduled...

Ok, I went ahead and created a new account just for SQL Server. Added it to the Domain admins group, but then went into the e:\ drive where I'm creating...