Viewing 15 posts - 3,406 through 3,420 (of 7,499 total)
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
Maybe this can get you started :
select h.server as Server
, name as Job_Name
, description
, h.run_date as Run_Date
, h.run_time as Run_Time
, h.Run_Status as Run_Status
, h.message
from msdb..sysjobs s
left join
...
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:34 am
These topic options were described when SSC switched/upgraded the forum software back in the days. 😉
On the other hand, if you want to print or copy the full topic at...
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 2, 2009 at 7:49 am
Fred Zimmerman (10/1/2009)
1) What do you set your Recovery to on your databases backed up.
2) Aside from stated Diff backups you do, do 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
October 2, 2009 at 2:15 am
So, for a "classic" tally table ( i.e. start with 1 increment by 1 ), Pauls solution performs best.
If you actually want a dynamic tally table ( i.e. 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
October 2, 2009 at 2:00 am
Viewing 15 posts - 3,406 through 3,420 (of 7,499 total)