• That was some nice stuff.

    Your other question - the same spid multiple times. This is caused by parallel processing. Look up the MAX DOP or Max Degrees of Parallelism in books online.

    Also, if your query is waiting a long time in SUSPENDED and you think it is the hard drive, use perfmon to look at the drive usage before and during the query running to make sure. If that is the case, you are likely to have a problem with your query and need to resolve it.