Viewing 15 posts - 5,011 through 5,025 (of 7,502 total)
Indeed, changes to the underlying table's column order will make a bitmapped trigger buggy, and there is no way you can avoid it becomming buggy ...
Best is to seal 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
April 1, 2008 at 12:36 pm
you can provide the location at install time:
- using the install GUI (advanced button)
- or using an installation INI file.
there is a template.ini file on your...
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 31, 2008 at 10:39 am
afaik : Yes you will have problems !
They can open in tran-scope, but they can only be closed after the tran-scope has completed.
Reason: MSDTC needs open connections to perform 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 31, 2008 at 10:34 am
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
Viewing 15 posts - 5,011 through 5,025 (of 7,502 total)