It looks as a "Lock" problem. SQL Server tends to switch to PAGE LOCKING when dealing with larger amounts of data. This is an automatic mechanism that occurs to streamline...