Viewing 15 posts - 2,176 through 2,190 (of 7,506 total)
Like I retweeted :
RT @AdamMachanic: Congrats to new SQL Server MVP Paul White!!! @SQL_Kiwi This is a blind RT, because if he wouldn't be in, nobody would !
Congrats Paul !...
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
April 2, 2011 at 1:21 am
phbarn (4/1/2011)
You made a good point with your reply and provided very good alternatives and how-to's,
however ....
please keep in mind this is an old thread ( Posted 1/21/2008 )
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
April 1, 2011 at 7:58 am
good feedback.
I ran across mrdennys article last night, but had quit a busy day today.
It's good you posted the ref for later forum users.
mrdenny is very frequent on Twitter (...
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 30, 2011 at 11:09 am
Do any of these queries result in rows ?
use msdb ; -- forwarded messages
go
SELECT '' as 'Q_000', *
FROM sys.server_event_notifications
order by name
go
select '' as 'Q_000a', *
from sys.server_triggers
select...
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:58 pm
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
Viewing 15 posts - 2,176 through 2,190 (of 7,506 total)