I recently came across a fairly detailed article on MSDN (article link) after a co-worker asked me a question regarding server resources when a query has been executed and you are using a DataReader to fetch one record at a time. The article goes into some of the standard SQL server architecture that I have known for quite some time, but it also points out some interesting details that may come in handy down the line. I am a bit busy right now, so I am marking this here so that I can come back and read the article in detail later.