I have a custom list with more than 5000 items. This article: http://msdn.microsoft.com/en-us/library/ff798465.aspx (the last section, "How Does Indexing Affect Throttling?") states: "For ...
I have an SPQuery that has been working fine until my list hit 500 items: q.Query = "<Where><Eq><FieldRef Name='DefectID' /><Value Type='Counter'>" + DefectID + "</Value>...
I have a SharePoint list that contains multiple fields. One of which is a multiline "Notes" field that is not included with the default view. When I perform a search on the list, I can search on any ...
I have a screen where the user will be querying using all columns in the list. Should i index every column. What are the rules around this? Would there be any performance problems?