Expensive Transact-SQL queries are generated in the back-end instance of SQL Server when you perform a search in SharePoint Server 2007
SYMPTOMSOn the Advanced Search page in Microsoft Office SharePoint Server 2007, you add a property restriction as a search condition. When you perform a search that is based on the property, the search may time out, or it may take a long time to finish. When this occurs, expensive Transact-SQL queries are generated in the back-end instance of Microsoft SQL Server. This may cause a decrease in performance in the back-end instance of SQL Server. RESOLUTION
To resolve this problem, install hotfix 950280. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 950280 (http://support.microsoft.com/kb/950280/)
Description of the SharePoint Server 2007 hotfix package: March 21, 2008
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
| Article Translations
|

Back to the top
