And this[/url].

vijay.vesanekar (8/8/2016)

---

Hi ,

I have implemented this logic at client side it helps to improve the performance

Before Logic (Time Taken) 18 Hr to 24 Hrfor 66 Rows

After change in logic...

Thanks.

Firstly, the estimate of the rowcount coming out of the table join is on the low side: as a result, the sort operator supporting the stream aggregate is twice as...

radu.gheorghiu (8/8/2016)

---

I'm sorry, I'm posting this issue on multiple websites, lost track a bit and forgot to mention it was a simplified version of the original query (that's why there...

radu.gheorghiu (8/8/2016)

---

Thanks for the suggestions, actually the query posted above is a bit obfuscated, changed column names / some aliases etc. but the obfuscation from SQL Sentry worked much better...

Hi Mitch, thanks for posting. It looks a little over-engineered for what it's supposed to be doing. This does the same much faster and with less code:

DECLARE @ExtraYearsEitherSide TINYINT =...

Hugo Kornelis (8/5/2016)

---

I did?

Really?

I always say that...

Hugo Kornelis (8/5/2016)

---

ChrisM@Work (8/5/2016)

---

Grant Fritchey (8/5/2016)

---

BLOB_EATER (8/5/2016)

---

I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a...

Grant Fritchey (8/5/2016)

---

BLOB_EATER (8/5/2016)

---

I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of knowledge.

My...

SQL Sentry Plan Explorer has an obfuscation option - so you can mask actual table and column names to get around NDA's. Since you've already published the original query a...

TSQL Tryer (8/5/2016)

---

I have a field called Address1 in my table Table1.

Here is an example of data in that field -

8 Brick Lane and 11 Balkerne Drive or it could...

DECLARE @EndDate DATETIME = GETDATE()

DECLARE @StartDate DATETIME = DATEADD(YEAR,-1,@EndDate)

SELECT @StartDate, @EndDate;

WITH t1 AS (SELECT * FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) d (n)),

t2 AS (SELECT n = 0 FROM t1 a, t1 b),

t4...

radu.gheorghiu (8/4/2016)

---

Ok, I will do so and post it here.

But if I look at the cached plans and this is the one whose last execution time was during the execution...

radu.gheorghiu (8/4/2016)

---

The execution plan is taken from:

, cast(qp.query_plan as xml)[Execution plan]

from sys.dm_exec_query_stats as qs

cross apply sys.dm_exec_sql_text (qs.sql_handle) as st

cross apply sys.dm_exec_text_query_plan (qs.plan_handle, qs.statement_start_offset, qs.statement_end_offset) as qp

And as per documentation, it...

That makes it an estimated plan.

--...