Most of the select statement is a non-issue.

Run this, see what it produces. There's got to be something subtly wrong with the values somewhere.

SELECT

ser.Patient_Primary_Policy_Carrier_ID,

'[' + ISNULL(cval1.Control_Value1,'') + ']'

cval1.Control_Value1,

CASE

WHEN ser.Patient_Primary_Policy_Carrier_ID =...

Kwisatz78 (12/3/2009)

---

Ok this is where my understanding is weak, how can I see what queries have CXPACKET or SOS_Scheduler_yield waits? and further to that how do I then look...

No. The SQL installer can, if run with specific parameters, rebuild the master...

Why?

What you should have is alerts that warn you when the disk is getting full (80% as...

Kwisatz78 (12/3/2009)

---

Yesterday I did a reset of the wait stats and since then in the view sys.dm_os_wait_stats CXPACKET is the second highest with a count of 3271668 with SOS_SCHEDULER_YIELD highest...

Ok, looked around and seems there's both definitions of internal and external fragmentation. I usually use them to mean fragmentation internal to SQL (and fixable within SQL) and fragmentation external...

Please post queries, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Why? Is that index used?...

It doesn't make the slightest difference how critical the situation is. You have to...

tnocella (12/2/2009)

---

Create Procedure p_myproc1

Begin

SELECT 1

End

--- Proc 1 just returns a value of 1 through a select

Create Procedure p_myproc2

Begin

Declare @Result int...

Well, yes. That's what you want isn't it?

I basically...

Ok, don't know what the rest of the query looks like, but to be 100% sure that we're looking in the right place at the right rows, please complete and...

It does allow the scenario where returning...

You're not relating the subquery in any way to the table that you're updating, so, for each row of the table that you're updating, ALL of the rows in the...

Declare @Result int

exec @Result = sp_myprocedure @Param1, @Param2, @Param3

Aside, don't name stored procedures sp_<whatever>. sp_ means system procedure and, if a proc is named that, resolution is first to the...

There will...