Viewing 15 posts - 2,176 through 2,190 (of 7,502 total)
As always ... Happy To Help 🙂
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 11:53 pm
Perry Whittle (3/29/2011)
do you have any SQL Server 2008 policies in force that may be disabling it after enabling
Ah, yes, that may even be the most trivial point to start...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 2:10 pm
Tank your for the feedback.
I did a good deed today 😀
Regarding cursors: In many cases cursors can be and should be avoided.
SSC has got a couple of good article...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 2:08 pm
Did you try dtcping and dtctester?
Did someone alter DNS settings, firewall stuff ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 1:36 pm
FYI a couple of MS refs that might be helpfull
- http://support.microsoft.com/kb/899115
- http://support.microsoft.com/kb/900216
- http://support.microsoft.com/kb/919034
- http://technet.microsoft.com/en-us/library/aa997579%28EXCHG.80%29.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 10:56 am
Brandie Tarvin (3/29/2011)
ALZDBA (3/29/2011)
C:\WINDOWS\Cluster\cluster.logI was about to ask that question. My server guys just gave me a funny look when I asked them. @=)
That's a prosperous observation :crazy:
Other Q may...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 8:17 am
C:\WINDOWS\Cluster\cluster.log
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 8:11 am
chances are you we reading my previous reply at the time I edited it.
Did you have a look in the cluster service log file ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 8:09 am
can you provide OS info ?
Clustering is one of the things that has been "enhanced" vastly with the differen os versions
Did you have a look in the cluster service log...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 8:02 am
yet another alternative ... raise an error that is being captured by sqlagent.
http://www.sqlservercentral.com/scripts/Miscellaneous/31032/
If you're not comfortable with the sqlengine you are using, don't go for the service broker solution;
If it...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 7:56 am
GSquared (3/29/2011)
If your actual data is much larger than this, you might get a performance improvement by adding a piece to the Where clause that limits it to only updating...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 7:47 am
that's what an outer join is all about.
In your case I would use a left join. It will return NULLS for its column values for the non-matching rows
I see...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 7:33 am
there must be some trigger / notification service capturing your action and reverting it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 7:20 am
did the provided script match your question ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 6:22 am
bitbucket-25253 (3/28/2011)
Would some one here help this OP (and when following the link also note Jeff Moden's request for some one to help the OP)http://www.sqlservercentral.com/Forums/Topic1085256-9-1.aspx#bm1085260
Took a shot. 😉
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 29, 2011 at 1:33 am
Viewing 15 posts - 2,176 through 2,190 (of 7,502 total)