This is a good example of calling a 2000 DTS package.

What is the logical equivalent for a 2005 Integration Services package?  Since they aren't necessarily stored on the server, is...

Setting it large or setting it small?

We're encountering a similar problem, a bulk copy operation is taking far longer than anticipated, and we're looking for tuning ideas.

I've actually implemented a structure similar to this, and it is surprisingly powerful for Warehouse querying.

Imagine you get this query (like I did) "I need to know the average number...

We hadn't been, as this third party application included a "reindexing utility" that (allegedly) handled index maintenance after every load.

Problem...it appears that it basically just does the very surface index...

You can see them in taskpad inside Enterprise Manager for the database.

As it turns out, though, that number is deceptive, as it was based off some old statistics.  Apparently 2005...