Thanks Luis,

I created your version of the function as ProperCaseLuis() and ran the same query with the function; the resulted CPU time for the query has not improved.

The main problem...

Thanks Luis.

We haven't installed any updates/SP

Below is the function definition.

[font="Courier New"]

Create Function [dbo].[ProperCase] ( @input varchar(4000) )

Returns varchar(4000)

As

Begin

-- Remove leading/trailing white space

Set @input = ltrim(rtrim(@input))

--...

Thanks Perry for the advice.

Sorry Perry, that was a typo, I meant to say 4-node cluster across 2 sites A and B, 2 nodes in Site A and 2 nodes in Site B.

Thanks Suresh for the quick response.

I disabled Named Pipes and Shared Memory, only TCP/IP is enabled. Restarted the server.

Still have the same problem, even if I specify TCP/IP as...