Hi Gail
Nice article... presented in very easy to understand manner
One question may not be entirely related to this topic
Say there is a big data modification (update statement) going on and not all pages affected by the update stmt are in the buffer/memory. Will the pages not in the memory be first fetched into the memory and then changed ? Or will the change be in the log and then written to the disk without the pages being brought to the memory?
Thanks
"Keep Trying"