Jim Murphy (7/13/2011)

---

Ninja's_RGR'us (7/13/2011)

---

Jim Murphy (7/13/2011)

---

I'm afraid so. Although you answer was great, and fully answered the question, I've tried to google both...

Quite possible. That section was added like 10 years after the original site.

Here's a sample concat script. I can't adapt it for you needs without table structure and sample data.

SELECT

T.name,

STUFF((

...

What do you mean by separate?

That explains why I never had that warning and why it's not fixing itself.!!

Time check for fragmentation, run update_stats on all tables with fullscan if you have a big enough...

Can you create a sample data set (select with union alls) and post what you have in a rdl file? I'm not too sure I understand what you need...

Jim Murphy (7/13/2011)

---

I'm afraid so. Although you answer was great, and fully answered the question, I've tried to google both the OP question...

...Still waiting on (at the very least) the actual execution plan and index ddl.

ejoell 66477 (7/13/2011)

---

I thought the JOIN(hiddenParameter, ",") would be just what I needed. Unfortunately all I get is a list of "#ERROR". And it still returned one row...

What do this return for this DB?

SELECT

is_auto_create_stats_on

, is_auto_update_stats_on

, is_auto_update_stats_async_on

, *

FROM sys.databases

Stats should pretty much take care of themselves!

Care to share (even if only in private)?

I didn't say useless index, I said useless lookup after the index seek. Whenever you have an index seek and then a bookmark lookup to fetch only 1 more...

There's still loads wrong with this.

You still have a missing stats warning.

The plan optimisation times out rather than complete

On the Score table the server estimates 1K rows but finds 65K,...

rgtft (7/13/2011)

---

Major thanks to everyone (especially Ninja's_RGR'us); the whole select is down to a couple of seconds. When the owner of this DB comes back, I'll talk with him...

Ninja's_RGR'us (7/13/2011)

---

I'm retracting my comment on the less reads comment about include.

I remember doing testing in the past with conclusive results but further tests show very little improvement on another...