This is a behavior I thought I'd point out, in case anybody is running into it without knowing the reason, as it may not be intuitive... :-) If you have an indexed field and are filtering by it, but it doesn't work even though you are positive the list doesn't have more than 5k (or whatever you set...

I thought I'd make one post where I link to all the SharePoint 2010 large list documentation.. Hope this is helpful: Large Lists help topic explaining the basic thresholds: http://office2010.microsoft.com/en-us/sharepoint-server-help/manage-lists-and-libraries-with-many-items-HA010378155.aspx?redir...

In this post titled "How to change the List View Threshold and Other Resource Throttling Settings", I described why you might want to use the "List View Threshold for Auditors and Administrators", which is 20,000 by default. This limit is higher than the default 5,000 List View Threshold that gets applied...

One of the major reasons that this List View Threshold (LVT) feature was created is to protect the server from unintentional load that may either bring it down, or at least cause other users higher latency or failures. Changing this limit (default 5000) is quite simple, but I wouldn't recommend it unless...

I made a post on the official blog of the Microsoft SharePoint Product Group about how to temporarily disable the large list "List View Threshold" feature on a large list. The post talks about your options for performing throttled operations on large lists, and why you might need to (for example - right...

Here's a link to the post I wrote a while ago. It's applicable to SharePoint 2007 moreso than SharePoint 2010, but you might find it an interesting read nonetheless. http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?ID=162 Dina