Viewing 15 posts - 5,011 through 5,025 (of 7,499 total)
well ... the "old" way ..
in stead of sending one mail to x recepients.... send x maild to one recepient at a time.
seems like a bug in your xpsmtp ...
Is...
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, 2008 at 5:40 am
columns_updates just says is a column is updated, it does not contain the value.
from bol
To test for updates or inserts to specific columns, follow the syntax with a bitwise operator...
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, 2008 at 5:34 am
- is this step run with another user than the rest of the job?
-since you're on sql2005 (forum) did you try it with dbmail ?
(avoid the overhead of mail-client)
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, 2008 at 5:25 am
If you put your db-files on a remote disk, you are network dependant !!! (availability/latency).
Sans are directly connected to your server and are prefered.
Sans are used like any local drive,...
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, 2008 at 3:10 am
like it says User Defined Function is supposed to perform some kind of
functionality (e.g. calculation, regex, ...) for you.
Most of the time based on parameters (row-level !).
Keep 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, 2008 at 3:03 am
- 8004005 is most of the time an authority issue.
- are you sending attachements ?
- post the jobstep / full job create script, maybe we can help out.
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, 2008 at 2:57 am
I would suggest to use the tool it is normaly managed with.
i.e. dcomcnfg
Especialy if you are not familiar with these settings !
Keep in mind these are also security settings !!!
You...
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 28, 2008 at 2:20 pm
why would you even think of using dynamic sql for this ??????? :sick:
If you know it's only the predicates that differ, why not have a bunch of if statements...
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 28, 2008 at 2:13 pm
first of all you'll need sql2000 enterprise edition !
This is the ref I always use : http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.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 28, 2008 at 2:07 pm
- Did you take a look at log-shipping ?
- or work with full backup once a week and the other days restore the db and apply (the smaller)...
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 28, 2008 at 2:03 pm
Can you find anything in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap
Take a look at the logfiles of your install processes (even if they seem cryptic).
And make sure you're connected to the...
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 28, 2008 at 1:57 pm
Actualy , today I had contact with MS, and it turned out to be a flaw in SP_Helpuser (since SQL2000 RTM)
SP_helpuser calls sp_helpgroup wich truncates this to 25 chars.
If you...
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 28, 2008 at 7:18 am
GilaMonster (3/27/2008)
Read committed is the default isolation level for SQL Server. There's no need to set it explicitly....
Well, you know how it goes with defaults , someone may have tampered...
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 28, 2008 at 12:52 am
Thank your for the corroboration. I was feeling very alone 😉
Indeed, you cannot do a thing about it, but open a case at MS (because it actualy IS a flaw)...
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 28, 2008 at 12:49 am
If volume is increasing, desing flaws may escalate !
is this select * executed from Query analyser or are they using a cursor to walk throug it ?? :ermm:
- You 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 27, 2008 at 9:03 am
Viewing 15 posts - 5,011 through 5,025 (of 7,499 total)