The overall problem with the question is its relevance. In my experience, I have never added a field with a default value and not set it to required. Isn’t that...

ok Cammy here is a pretty good outline. The basic idea is instead of attempting to pass back the data with a SELECT, it inserts it into a table seen...

It's possible, but it is more likely that the server was restarted recently and the cached plan was not the most optimum. Whenever an object is executed for the first...

Your logic is a bit backwards. You need to think of the procedure as being the master of the query. Within you procedure you can perform an infinite number of...

It would be a wait due to a lock and the SPID would never be blocked.

What happens internally is SQL Server starts a snapshot read. If the data changes before...

Ajroney,

I need some more info:

  Is this the first time you have used the query with the variables?

  Has the size of any of the view tables changed resently?

Chad,

Everything you described is accurate. Your only option, given the supplied information, is to have your procedure perform a "dirty read". I think all the performance items you have added are not...