Viewing 15 posts - 3,406 through 3,420 (of 7,503 total)
In that case, check your databases ! One of them (if not all) may contain a wam_bam schema name !
And the user may have that schema name as default schema,...
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
October 12, 2009 at 1:04 am
Thank you for the feedback.
That kind of mishaps happen to all of us every once in a while 😉
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
October 12, 2009 at 1:02 am
Once again, thank you Dale.
Your advise and refs contained the solution to fix the issue that occured on some of our x64 systems.
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
October 12, 2009 at 12:58 am
Some nasty little virus kept me in bed the last days of last week. :sick:
If you read my script, you'll see a section of the where clause where I added...
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
October 12, 2009 at 12:26 am
Just to add to Lynns reply :
Start with reading these eluminating articles:
- http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/
- http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
- http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/
- http://www.sqlservercentral.com/articles/Advanced+Querying/fourrulesfornulls/1915/
You have to understand NULL means "unkonwn" !
You are inserting an empty string so we...
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
October 7, 2009 at 12:09 pm
Is wham_bam a windows group by any chance !
You need a windows user account to be job owner.
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
October 7, 2009 at 11:54 am
It's a petty you didn't post the full sproc.
- Are you reusing cursor names ??
- what happens in sproc EMR.HPSITE.CAREGIVER_SaveLocation ?
Is it also using a cursor ?
...
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
October 7, 2009 at 11:49 am
It actually is a question every mature dba must pose !
- Just to put people back with their feet on the ground.
- to determine if performance may be...
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
October 7, 2009 at 8:06 am
What about sequenced shifts .. should the emp clock out and back in ?
I have elaborated a bit on Dave Ballantynes provided script.
declare @sched table ( EmployeeId int not null,...
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
October 7, 2009 at 6:20 am
How does this system handle night shifts ?
EMP-1 7-10-2009 22:00 ...
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
October 7, 2009 at 2:10 am
- did you grant the needed auth for your service account on the windows folders at the new drive ?
- did you follow the procedure as explained in BOL ?
-...
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
October 7, 2009 at 1:54 am
You need to provide access authority to the new file location(s) to your sqlserver instance service account !
For startup parameters of SQLServer, check out Books Online topic "Starting and Restarting...
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
October 6, 2009 at 7:53 am
Prepare your operation by determining which objects you want in which filegroup.
Just a couple of helping scripts:
http://www.sqlservercentral.com/articles/Administration/64275/
http://www.sqlservercentral.com/scripts/Miscellaneous/31541/
Another forum Q handling about the same subject:
http://www.sqlservercentral.com/Forums/Topic797121-1291-1.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
October 6, 2009 at 7:47 am
Give me a moment to whipe out a teardrop of nostalgia :alien:
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
October 6, 2009 at 3:58 am
just a couple of helping scripts:
http://www.sqlservercentral.com/articles/Administration/64275/
http://www.sqlservercentral.com/scripts/Miscellaneous/31541/
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
October 4, 2009 at 6:38 am
Viewing 15 posts - 3,406 through 3,420 (of 7,503 total)