Paging Limits control how many items show up on the list pages in crm. Most notably advanced finds. I like to be able to display a lot of information, and I need to be able to run operations on more than 250 items. Using the following SQL query I was able to increase my paging limit to 1000.
UPDATE UserSettings SET PagingLimit=1000 WHERE SystemUserId IN (Select SystemUserId from SystemUserBase WHERE FullName like 'Carlton%')