Nevermind...

Per the BOL:

Parallel index operations are available only in SQL Server Enterprise, Developer, and Evaluation editions.

🙁

I'm using SQL Standard.

Newman!

Sam

Waddaya know! That's cool. I did the "estimated plan" (see attached). There's not much too it, but the "actual plan" does say a lot more.

Shame...

No, I meant for my non-clustered index creation statements (put on after my data is already loaded up).

Thanks anyway,

Sam

Historically, I've had better luck with the clustered index pre-existing...

I tried loading up the table "in order", and then adding the clustered index, but it performed worse.

Shame the...

I found that granted read/write access (for the Agent account) to the following folder resolved the issue:

C:\Program Files\Microsoft SQL Server\80\Tools

Just my 2 cents...

Sam