thank you very much for your help.

Orlando Colamatteo (11/28/2015)

---

Monitoring multiple instances implies you need something that can reach out over a network and compile and display results from multiple servers. PowerShell is a good choice for...

Hi Orlando,

Can you please tell me what the following query does?

SELECT

@CPUusage=(cast(CAST (A.cntr_value1 AS NUMERIC) / CAST (B.cntr_value2 AS NUMERIC) as decimal(18,3)))*100 ,@CPUusagebase=cntr_value2

FROM

(

SELECT cntr_value AS cntr_value1

FROM...

i just need to measure the cpu usage across different times during the day to get peak hours and see how much cpu goes up at those times.

This will get the usage per each sql, what if i just want the CPU usage on the server, any SQL to get...

anthony.green (10/29/2015)

---

If you have a reversed string in a computed column and then add an index to that column

Your string then looks like nixcba for example.

You can then full text...

I guess they did it that way to be SARGABLE, am i right?

But then will i gain performance wise by implementing the FTI over the normal like operator?

I changed the query to select * from namingtrades where contains(tradename,' "xin" ')

as you suggested...

Thanks Chris and Ed for your replies, i will check those articles.

Thanks Jayanth_Kurup for your reply.

In...

Jeff Moden (10/21/2015)

---

Not enough coffee, yet. Made a Copy/Paste mistake.

Here's my shot at it. I'll do a performance test tonight (on my way to work just now).

--===== Build...

Lynn Pettis (10/19/2015)

---

Would something like this work?

declare @InputValue as varchar(50)='ttttest',

@Word varchar(50);

with e1(n) as (select 1 from (values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1))dt(n)),

...

Jeff Moden (10/19/2015)

---

In future posts, I recommend you post to...

I...

Thank...