I have the same problem. The wait_source of the active session is blank (NULL). The last wait resource was SOS_SCHEDULER_YIELD.

I'm trying to do multiple inserts into the same...

Great article. I have some questions though:

Recovery Modes

Is there a performance difference between the recovery modes?

Or are the recovery modes really providing the feature for database recovery...

When do checkpoints happen? Are they automatic? Can they be invoked programmatically?

Besides simple recovery, are there other techniques to minimize the size of the transaction log?

Thank you,

Jake

Has anyone compared the performance of a MERGE statement with the "old" standard of UPDATE and INSERT? Specifically with regards to data warehouse loading.

Thanks,

jake