In Microsoft SQL Server 2005, you run a warm query to obtain information from the Microsoft Search service. When you do this, the operation may take longer than you expect, and you may notice increased CPU usage. This problem occurs if the query is designed to perform a full-text search.
Read More - Register for Free Membership
