The proc_GetContentTypeIdFromUrl stored procedure takes a long time to retrieve the content type identifier of a document if many documents are in a SharePoint Foundation 2010 site.
Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.