I think that's pretty much what is happening because he is using this select statement as a table in a inner join.

Thank you everyone for your replies. 

Each shapefile is going to describe a fire perimeter that is the result of a fire spread prediction simulation.  Essentially, it is going to...

Each user uploads a unique file based on their session ID, the file is renamed, saved to the filesyystem, then opened using the stored procedure.  It seems to be working...

I am thinking that snapshot replication may be the way to go in this situation.  My DTS is pretty rusty, and I have like five databases with a bunch of...

Wonderful article.  Thank you.

Thanks much.  I ended up using the top solution.  Thanks again...

Thanks much...

The problem was that the transaction logs were never truncated, so they were gigantic.  Thanks