Try this trigger:

CREATE TRIGGER RAC_logon_trigger

ON ALL SERVER

WITH

EXECUTE AS 'sa'

FOR LOGON

...

It's also not such a bright idea to create a new object in tempdb on every logon.

Get rid of @IP and replace it with a static table:

1. Hardcoding parameters is...

Why do you need all those horrible XML and dmv queries?

SELECT @SessionId = @data.value ('(/EVENT_INSTANCE/SPID)[1]', 'int');

SELECT @HostName = @data.value ('(/EVENT_INSTANCE/ClientHost)[1]', 'sysname');

...

ChrisM@home (5/26/2016)

---

Such clustered may be very good on query but it's gonna be a very high cost...

John Mitchell-245523 (5/26/2016)

---

Do you mean (report_id, flow_name, report_item,...

jc85 (5/26/2016)

---

Sergiy (5/25/2016)

---

If that one goes not so bad then incorporate it into the bigger one:

SELECT dateadd(dd,0, datediff(dd,0,b.start_time)) as [date], b.source, b.lang, SUM(b.sel_test) Test, SUM(b.sel_test2) Test2

FROM TechDetails b

WHERE b.start_time...

SUM(-GL10111.CRDTAMNT + GL10111.DEBITAMT + PREV.PERDBLNC - GL10111.PERDBLNC) - ( GL10111.DEBITAMT - GL10111.CRDTAMNT )

Something does not look right here.

There are 2 ways to go.

1. Pay to a qualified SQL developer who knows about normalisation rules and tends to follow them to develop a new, proper database to support...

If that one goes not so bad then incorporate it into the bigger one:

SELECT DT.date, (a.source + '-' + a.report_item) as report_item,

SUM(CASE WHEN b.lang = 'EN' THEN CASE a.report_item WHEN...

How does this query perform?

SELECT dateadd(dd,0, datediff(dd,0,b.start_time)) as [date], b.source, b.lang, SUM(b.sel_test) Test, SUM(b.sel_test2) Test2

FROM TechDetails b

WHERE b.start_time >= @StartDate

AND b.start_time < dateadd(dd,0, datediff(dd,0,@EndDate)+1)

GROUP BY dateadd (dd, 0,...

jc85 (5/25/2016)

---

Thanks ChrisM@Work.

The query took quite some time to complete.

Additional info provided in case you need it.

ann_events_Tech_Details

[start_time] - clustered index

[id] - Unique, non-clustered index (PK)

ann_ReportItem

[source] - non-clustered index

[call_flow_name] -...

This is exactly the problem.

Make both PK's non-clustered and create a new clustered index on...

Lynn Pettis (5/24/2016)

---

I have to agree with Steve. I would also look at the indexes you have on the tables. If you have good clustered indexes that don't...

Make it clustered.

Otherwise - drop it, no use of it anyway.

[Source] must...

There is simply no way to actually disallow xp_cmdshell.

If you know one - please share it with us.