Forum Replies Created
Viewing 15 posts - 6,046 through 6,060 (of 7,499 total)
RE: Job Step Duration
I've just copy/pasted the script and added the last inner-join-part.
It returned rows. (with sql2000 and with sql2005)
This is the full script, copy/paste it and run. It should give results if...
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
RE: constraint: enforce unique key on subset of rows
just to add to the other replies :
you could use triggers to enforce this check constraint.
Although its better to avoid ....
CREATE TRIGGER mytrigger _IU ON mytable
FOR insert, update
AS
BEGIN
if exists...
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
RE: Job Step Duration
or maybe even replace the complete where clause with
inner join
( select job_id, max(run_date) as Max_run_date
from msdb.dbo.sysjobhistory
group by job_id ) jhMAX
on jh.job_id = jhMAX.job_id
and jh.run_date = jhMAX.Max_run_date
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
RE: Job Step Duration
there is also a litle pitfall with ...
and jh.run_date = convert(int, Johan Dont drive faster than your guardian angel can fly ... - How to post Performance Problems - 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
Learn to play, play to learn !
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post data and code to get the best help
RE: New SQL Server 2005 instance, really slow compared to 2000
- how long is it taking the system to allocate 200GB ?
- did you try to copy a 200Gb file to that logical disk ? And how long did that...
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
RE: New SQL Server 2005 instance, really slow compared to 2000
so this may be I/O related.
keep in mind that files are being initialized (=nulled out) at allocation time (unless you specify not to).
What filesize are you trying to allocate ?
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
RE: Job Step Duration
how about :
declare
@daysago int
set
@daysago = 7
Select
j.name as Johan Dont drive faster than your guardian angel can fly ... - How to post Performance Problems - 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
Learn to play, play to learn !
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post data and code to get the best help
RE: install 2nd clustered istance messes up SQLBrowser !
thanks for the feedback.
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
RE: New SQL Server 2005 instance, really slow compared to 2000
Indeed the GUI stuff is very slow.
IMO the datapart is greath.
regading you filegroup-slowness ... I didn't encounter this.
Is it with the creation of the filegroup, or of the files within...
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
Viewing 15 posts - 6,046 through 6,060 (of 7,499 total)