Can somebody explain me one more thing?

I have again problem, but on another query, after using this hint I got good results,, without it same like without optimize..

Without hint Ex.plan...

Thank you, I am glad also 🙂

here is my optimizing progress ,,original procedure it was very slow, I dont understand how the programmer can be satisfied with this..

BEFORE

With Parallelism

Table 'TB_RCV_ALCDATA'. Scan count 9, logical reads...

OK I fixed so for declare @TEMP_ORDER_DATE use this

DECLARE @TEMP_ORDER_DATE char(8)=(

SELECT TOP 1 PROD_DATE FROM

(

SELECT PROD_DATE,

ROW_NUMBER() OVER (ORDER BY PROD_DATE asc ) AS Row1

FROM( SELECT distinct top 4...

And now I found one thing, if it will be data like I sent, only from one day with one PROD_DATE, the query above for @TEMP_ORDER_DATE will be null or...

I forgot script for tables and data, in attachment you can see. I hope that is it in right format, I didnt do long time .. but in our tables...

this is query - I have procedure for this, problem is that TB_RCV_ALCDATA table is very sensitive, there is lot of data and this table use lot of programs and...

thanks for answer

I have to remember index and statistics, I forgot for this almost every time during investigation ...

Maintenance plan is at saturday, so I rebuild all indexes and...

John Mitchell-245523 (11/19/2013)

---

You need a DDL trigger, not a DML trigger. But I would recommend looking at service broker or extended events if you are looking at setting up...

I wanted to delete before, but i dont know where and how.. sorrz for spam

Hello, I think that this one is better, I will see, but I tested on test server and it looks good -- sqlplan in attachment

What do you think about it...

This procedure is in timer 1second and on 3positions, and...

GilaMonster (10/31/2013)

---

tony28 (10/31/2013)

---

slower queries are important but i think the CPU time = 78 ms, elapsed time = 79 ms are ok no??

or do you think that is it problem...

yes thx ,,..

slower queries are important but i think the CPU time =...

GilaMonster (10/31/2013)

---

tony28 (10/30/2013)

---

GilaMonster (10/30/2013)

---

Don't look at scan count. It is not the number of times a table has been scanned, it's not consistently the number of times a table has...