Christian Buettner (9/1/2008)
If I had known that Hugo is the author of the QOTD, I would have chosen the correct answer.So how about including the author in the QOTD description? (Not only in the forum part)?
But still, very good question as well as explained answer!
Well, if you have the daily emails sent to you, then the author is stated in the QOTD section in the email:
Question of the Day
Today's Question:
You have been asked to optimize a stored procedure that runs against a terabyte-sized database. The stored procedure executes several steps consecutively. The performance problems appear to be mainly I/O related.
You install a severely trimmed down test version of the database (1 GB in size) on your desktop computer running SQL Server Developer Edition. Before you start optimizing, you want to establish a baseline by timing the stored procedure on your development machine, so that you can later compare performance after adding indexes and tweaking code.
However, your desktop has 2 GB of memory installed, and you are concerned that the performance test results may be skewed because the test version of the database fits entirely in cache. What is the best way to simulate the production circumstances as closely as possible?
By Hugo Kornelis
Also, if you go to the home page (http://www.sqlservercentral.com/) and take a look at the QOTD section of the left hand side of the page, the author is stated there as well:
Question of the Day
Simulating memory pressure
By Hugo Kornelis 2008/09/01 | Category: Performance