Allowing PostgreSQL to use an index when the query uses the LIKE-operator

When enabling search in database its very important to have the appropriate indexes defined to make the queries as fast as possible. If your query looks like this (and the appropriate index is defined) the index can be used by the database (the query planner) even with the LIKE-operator. So fast wildcard-searches are possible … […]

Cannot complete this action – error when adding a ContentType to a list

Today I got a nice error from my SharePoint development box after I tried to add a certain Content Type to a list. Cannot complete this action. Please try again. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd) at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)Cannot complete this action. Please try again. at […]