SharePoint 2010 - List View Threshold
Any well utilised SharePoint farm will hit this limit at one point or another, the annoying but not hard to resolve LIST VIEW THRESHOLD ISSUE!!!!!! If you're on the ball, you'll know to cater for this when first creating a list you know is going to be quite popular with the lads. This involves creating indexed columns, and creating views that filter on the indexed columns. But woe to those who wait for the dreadful message to appear, and also to those who prepared for it, but it is still occurring anyway. WHHHHHHYYYYYYYYYYYYYYYYYYY!!!!!!!!!!!!.... STOP! CAML TIME! Well it's because when you modify a view using the SharePoint GUI, and you filter on a indexed column and maybe a few others, SharePoint turns your filters & options into a CAML query, and if that query contained a few different column filters, SharePoint occasionally doesn't render the CAML query in a manner that ensures you are always querying less than the List View Threshold! OH N...