Viewing 15 posts - 5,116 through 5,130 (of 7,502 total)
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...
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.
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...
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.
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"...
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...
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...
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...
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...
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...
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
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...
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...
March 5, 2008 at 10:23 am
Dave Callaghan (3/5/2008)...Why would doing it with QA be any better? More likely to make typing mistakes.
because EM will present you the old file-locations for all non-mdf files.
(if gets...
March 5, 2008 at 5:34 am
Viewing 15 posts - 5,116 through 5,130 (of 7,502 total)