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 been accessed...

Grant Fritchey (10/30/2013)

---

Your second query, the UNION, is getting a timeout from the optimizer. That means the plan is likely to be suboptimal. I'd suggest looking at ways to simplify...

GilaMonster (10/30/2013)

---

Doesn't mean it didn't happen. If you have locking problems, consider one of the snapshot isolation...

Grant Fritchey (10/30/2013)

---

Lots of NOLOCK in there. That's scary.

One thing you can do that will immediately help performance, whether you keep the recompile in place or not. The IF statement...

Grant Fritchey (10/30/2013)

---

Not seeing the query, I can't say what's going on, but, on a guess, you're probably seeing some sort of bad parameter sniffing issue where the plan you...

hello, in attachment is all.

The function is on the first page of topic and the one of procedure is page back .

Thx fo reply and advices

I understand, but I tried this. but result is null, i think that no more space for string...lot of columns..ok i will do few columns with 'A'

SELECT TOP 1000

'SELECT '

...

Lynn Pettis (10/17/2013)

---

Well, the word doc has the DDL but I am not taking the time to convert you Excel sheet to necessary format to load the tables.

You really need...

tony28 (10/17/2013)

---

here is one of procedure, which is slowlier thanks to function...

in the attachment you have in word all ddl from this, and in excel files for all tables 1000rows.

ALTER...

I did it.... but you can see... the no name column will be with cte , but you can see that performance is not good. maybe something is wrong

SELECT...

Lynn Pettis (10/17/2013)

---

tony28 (10/17/2013)

---

Lynn Pettis (10/17/2013)

---

tony28 (10/17/2013)

---

Before than i will give the design and data,

I forgot for I think important issue, If this function is using for example inside...

here is one of procedure, which is slowlier thanks to function...

in the attachment you have in word all ddl from this, and in excel files for all tables 1000rows.

ALTER PROCEDURE...

Lynn Pettis (10/17/2013)

---

tony28 (10/17/2013)

---

Before than i will give the design and data,

I forgot for I think important issue, If this function is using for example inside 20procedures, it can...

I thinking about modify to ITVF, but i think it will be very hard and slowlier like one query...

1. I have to declare variable

2. alone queries are very faster,...

Before than i will give the design and data,

I forgot for I think important issue, If this function is using for example inside 20procedures, it can causes this problem?...