Here's a thought, how about you provide some more details on what you're doing. Table schemas, stored procedure code, type of hardware the server is running on.

Th emore details you provide the more likely you are going to get an authoritive answer, rather than just a guess.