I have a painful problem - but the doc says it will go if I keep taking the tablets.

Anyway, I am trying to set up a linked server to MySQL...

Could do with a trip to the Gobi? he he

Could do with the rest (and tan), but it's only one way!!

Do you know, I know that shouting doesn't help understanding, but BOY is it tempting sometimes :):hehe:

As all the others said, as good as the blog is, forget it and get better soon.

Another thought - someone hasn't found the "forceplan" option have they?

I think that you are spot on to go check the application - or use profiler to drag out exactly...

Stats should be updated nightly, indexes rebuilt weekly (create a job that only updates stats that are above an arbitrary threshold, say, 75%).

Can you try and update the stats on...

Maintenance plan??

You can do that with a scheduled job easily enough.

Maruf, several people, including me, have suggested you update your statistics and then run the query again. You...

Chirag,

I think colname is just an alias to keep the fields anonymous 🙂

Other than the obvious reasons not to have that number of instances, if you have the hardware to cope with it, and you maybe need different collations, or case sensitivity....

Marfu,

Thats great.

Have you looked at the execution plan to see what indexes the query is using? If it is doing a table scan, then maybe you need to see if...

Kendal,

You are right in that if someone has access to your server, then there are bigger problems. But a server is a server - not a workstation.

I wasn't talking about...

Quite.

If you give the right answer to the wrong question,...

Kendal,

Whilst I see your point, I would never allow management tools on any database server. If you need to manage them, then you use a workstation with those tools installed....

I'm definately with Gail on this one.

I have been through this pain that you are about to embark on - it may be a long and painful path - and...

Have you put a "GO" statement to define the end of the procedure?