SQLSACT (9/26/2012)
If the page in memory cannot accomodate the insert, does SQL then just bring an extra page blank page from disk into memory?
Why would it need to read a blank page off disk?
When SQL Server removes a page from memory, does SQL put it right back where it was?
Put it back? When a page is removed from memory, it's just removed, it doesn't need to be put anywhere. It's just a cached copy.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability