CELKO (12/6/2016)

---

No, I get called in every now and then by product developers a lot of different SQL companies to...

It's no different from any other column. You either reference it indirectly through the view or...

Not that means that...

He already said that he had fixed it, but didn't remember what he did. And...

It's extremely difficult to troubleshoot performance issues without an execution plan (preferably actual). Can you attach the plan as a .sqlplan file?

In the meantime, you might want to try...

Now you're just making up stuff to support your claims.

Who cares?!?! Most people here...

adonetok (12/6/2016)

---

I tried the way from SSChasing Mays but got an error once I changed table name from "orders" to my table's name.

Where is "near '-'" from script?

(352866 row(s) affected)

Msg...

Here is the text.

create procedure sp_dailyreq

.....

SELECT u.id,

u.NAME,

...

Just include the @id and id values in your debug table.

INSERT INTO @DebugTable(

input_id,

id,

Result_On,

AlarmId,

[Target],

Result)

SELECT

@id,

id,

@AlarmStart,

@AlarmEnd,

Result_On

FROM @Results

Drew

Adi Cohn-120898 (12/6/2016)

---

You can use the profiler to show that. Another option is to use the extended events. You can see the amount of pages that the query...

@Sean, The splitter definition is in the query plan file.

CREATE FUNCTION [dbo].[fn_SplitString]

(

-- Add the parameters for the function here

@List NVARCHAR(MAX),

@Delimiter NVARCHAR(255)

)

RETURNS...

Recurs1on (12/5/2016)

---

drew.allen (12/5/2016)

---

I also notice that your deleting from tableA, but filtering TableB, so you're going to keep getting the same 10000 rows from TableB every time through the loop.

Have...

It sounds like the is_primary_replica condition should be part of the JOIN criteria instead of in the WHERE clause.

select ag.Name, ag.Group_Id, agl.dns_name as 'ListenerName', COUNT(db.database_id) 'DatabaseCount'

from master.sys.availability_groups ag

inner...

I also notice that your deleting from tableA, but filtering TableB, so you're going to keep getting the same 10000 rows from TableB every time through the loop.

Have you tried...

This probably doesn't meet the conditions for top rows per group....