Viewing 15 posts - 16 through 30 (of 38 total)
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
August 12, 2009 at 2:25 pm
Could do with a trip to the Gobi? he he
Could do with the rest (and tan), but it's only one way!!
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
April 29, 2009 at 4:20 am
Do you know, I know that shouting doesn't help understanding, but BOY is it tempting sometimes :):hehe:
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
April 28, 2009 at 3:34 pm
As all the others said, as good as the blog is, forget it and get better soon.
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
April 27, 2009 at 10:58 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
August 4, 2008 at 6:09 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
August 4, 2008 at 6:06 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
August 4, 2008 at 6:04 am
Chirag,
I think colname is just an alias to keep the fields anonymous 🙂
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
August 1, 2008 at 4:38 am
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....
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 31, 2008 at 8:58 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 31, 2008 at 6:42 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 8:19 am
Because providing the right answer to the question asked may not be the proper solution to the problem at hand
Quite.
If you give the right answer to the wrong question,...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 8:13 am
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....
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 7:54 am
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...
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 6:31 am
Have you put a "GO" statement to define the end of the procedure?
"Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein
July 30, 2008 at 6:14 am
Viewing 15 posts - 16 through 30 (of 38 total)