GilaMonster (9/8/2009)

---

ben.mcintyre (9/8/2009)

---

I badly need my views here. Due to the size of the data chunks I'm dealing with I have to wrap them in views to stay sane....

> Maybe it simply isn't apparent to you. You have changed the information and options available to the optimizer in a very

> complex construct. It does what it can...

Thanks, again, for your replies.

Yes, I was worried that I might be swapping one set of fast and slow plans for a new, different, set of fast and slow plans...

Hmmm ....

The silence in this thread is almost deafening.

Was it what I said about being Australian ? Those bloody 'Flight of the Conchords' guys have been giving us a...

Funny, but this instantly reminds me of all the other flavours of database in the world, running under *ix... Postgres, MySQL, Oracle, ...

It's standard practice to have a totally stripped...

Just wanted to say thanks in advance, I really appreciate any time anyone spends on this one.

I've combed the internet for years over problems like this and been completely unable...

STATISTICS IO and STATISTICS TIME

See Attachments

OK, here are the plans and a database diagram (attached).

I have simplified the query a bit, but unfortunately as I take bits out, it all runs fast and the problem...

Thanks for link. I'll post the plans in another day or so.

Yechh. I remember tearing my hair out over MDW's.

Anyway, the most important thing is: who (as in which user) is the Owner of the database ?

You should be able...

Yeah.

This might be a bit off topic, but this discussion reminds me a lot of reading Larry Wall's comments on PERL. PERL has a lot in common with SQL,...

There are some really weird things going on here.

But

Convert.ToInt32( AccountList[LoopVar] = i );

is dead...

The issues finally seem to be coming out in the wash here.

The main reason people are giving for sproc wrapping is that of providing a wrapper for the database.

I'd have...

I think some comments here are missing the point.

The question is not whether it is a good idea to use stored procedures, the question is, is it a good idea...