Jack Corbett (3/4/2014)

---

Issues with different white space characters is a pain. You just need to use the CHAR/NCHAR function in the REPLACE, like this:

DECLARE @data NVARCHAR(MAX) =...

Jack Corbett (3/4/2014)

---

I don't think there is any restriction on the # of characters REPLACE will work with as there isn't anything mentioned in BOL.

My best guess is...

Jack Corbett (3/4/2014)

---

Can you post the code you are using. I just tested using this:

DECLARE @data NVARCHAR(MAX) = 'EXEC Proc_gen @PsID=12, @kID=-1, @ID=3183';

SELECT @data AS theData...

If query cost is less than CTP it will always use only 1 processor?

sqlbuddy123 (2/28/2014)

---

curious_sqldba (2/28/2014)

---

I have read so many articles, may be i am just missing the point. My understanding is you set your CTP and MAXDOP, if the cost of a...

ChrisM@home (2/6/2014)

---

curious_sqldba (2/6/2014)

---

ChrisM@home (2/6/2014)

---

curious_sqldba (2/6/2014)

---

ChrisM@home (2/6/2014)

---

How are you choosing index 2 over index1?

Dropping index 1 and creating Index 2.

Why would you choose index 2 over index1?

I am not, i just...

ChrisM@home (2/6/2014)

---

curious_sqldba (2/6/2014)

---

ChrisM@home (2/6/2014)

---

How are you choosing index 2 over index1?

Dropping index 1 and creating Index 2.

Why would you choose index 2 over index1?

I am not, i just asked a...

ChrisM@home (2/6/2014)

---

How are you choosing index 2 over index1?

Dropping index 1 and creating Index 2.

Why would you choose index 2 over index1?

I am not, i just asked a question ...

I just want to script out given jobs, basically i am thinking of having a config file which will have...

So bulk inserts...

My understanding is if...

Keith Tate (11/6/2013)

---

That is simply the name of the output (one of them) from the Compute Scalar operation right before the sort. Also, you have some carnality issues with this...

RVO (11/4/2013)

---

I compared execution plans

with parameter 'VEH' and 'COM'

and in both cases it is this step that is taking up all the resources:

Index Scan (NonClustered)

[prj_detail].[IXN_prj_detail__per_end_date__detail_type_ind__evc_code__evc_type_code]

Cost: 91%

Another pattern I noticed is...

RVO (11/4/2013)

---

Ten Centuries,

"...Have you looked at indices and stats before changing the code?..."

No I have not done this.

I am not a big guru when it comes to TSQL performance tuning.

Can...

RVO (11/4/2013)

---

Guys, I am so thankful for your help.

I think parameter sniffing is definitely might be the root cause.

I am rewriting procedure now to use local variables.

Will let you know...