Viewing 15 posts - 5,116 through 5,130 (of 7,502 total)
with SSIS you can use the script component !
that one supports vbs.
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 7, 2008 at 4:56 am
Still I think your interviewer would have fallen asleep by about the 3th paragraph in your extended explanation. :w00t:
In the most optimal situation your interviewer would have had a...
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 7, 2008 at 12:17 am
you could define a sql2005 proxy that has the needed rights at the destination folder and assing that proxy to the jobstep.
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 6, 2008 at 11:59 pm
you'd be better off just launching a new thread.
but since we're at it.
afaik you can only sample and guestimate.
Keep in mind connections come and go...
fairly common usage of sysprocesses ....
e.g.
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
March 6, 2008 at 12:08 pm
did you try net use \\uncname\.... usersxxx pwdyyy
(keep in mind to unmap it in the next step)
Check dos-help
mapped drives are only for the user that is currently logged in.
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 6, 2008 at 9:54 am
Indeed, if you know you always have to compare data that strictly
defers 1 day, use the join with y1.Date + 1 = y2.Date
and don't use the "dynamic"...
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 6, 2008 at 9:24 am
I've had some issues applying the servicepacks (and you need to apply at least sp2 + cu2 (cu5 or 6 if you can)) on client installations having SQLExpress installed during...
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 6, 2008 at 8:56 am
What you can do is loose the left join.
No columns of these objects are actualy used in the result.
and the left contains a nested innerjoin, so this will not effect...
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 6, 2008 at 8:34 am
from a controled implementation point of view there is also datadude (vs 2005 team edition for dba), maybe that can help out.
But what if some priviledged sqluser justs grabs a...
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 6, 2008 at 7:37 am
I would not prefer using linked tables for this, but it can be used.
Is this copy realy needed online-realtime ?
Prefer the assynchrone way !
e.g.
use a sqlagent job to refresh 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 6, 2008 at 7:27 am
I think I didn't express myself well.
My suggestion was nothing else but a starting point !
Why would you need a cursor ?
If you need to do quit exact the same...
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 6, 2008 at 7:11 am
with sqlserver you can update one alias of a join directly.
e.g.
update T2
set colx = T1.coly
from mytableA T1
inner join mytableB T2
on T2.thekey = T1.TheMatchingKey
inner join someothertable T3
on T1.anothercol = T3.matchingcol
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 5, 2008 at 10:29 am
There is more to sql2005 then just the db-engine !
SSIS is something totaly different than dts.
May I emphasize you need to start with SQLServer upgrade advisor.
It checks your sql2000 sb/server...
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 5, 2008 at 10:24 am
should be doable.
may I emphasize you need to start with SQLServer upgrade advisor.
It checks your sql2000 sb/server and will highlight issues you need to address before the move !
also keep...
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 5, 2008 at 10:23 am
yep
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 5, 2008 at 5:49 am
Viewing 15 posts - 5,116 through 5,130 (of 7,502 total)