Viewing 15 posts - 4,351 through 4,365 (of 9,722 total)
My data source is a stored procedure which does a SELECT at the end, then sends records in two different directions. One to the file and one to a staging...
June 4, 2012 at 7:49 am
SKYBVI (6/4/2012)
If you memorise answers, you will be lost as soon as the interviewer digs into details. If you've played around and have practical experience you won't be.
Thats true I...
June 4, 2012 at 5:29 am
SKYBVI (6/4/2012)
1) Why clustered index are only 1 and non clustered indexes are many?
Also, if for a table we...
June 4, 2012 at 4:32 am
jcrawf02 (6/1/2012)
Koen Verbeeck (6/1/2012)
SSIS is a littly crybaby when it comes to changing metadata.Ha! So true...
I hate the XML Source. Any changes to the XSD file, and you have...
June 1, 2012 at 6:27 am
My recommendation. Make sure your SQL schema (as Koen said) is the same in the development environment. Get local copies of all dbs for development. Do some unit testing to...
June 1, 2012 at 5:51 am
Happy release day to meeeeeeee.
Legend of the Beemen & the June issue of Penumbra eMag (of which I was guest editor-in-chief) are now available for purchase: http://www.musapublishing.com/%5B/url%5D
Buy it... Buy it......
June 1, 2012 at 5:10 am
Koen Verbeeck (6/1/2012)
Cath Trimble (6/1/2012)
By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?
Wow, that's cheap by UK standards....
June 1, 2012 at 5:06 am
Is SSIS integrated with Powershell?
May 31, 2012 at 12:06 pm
DOH!
Nevermind. I found the issue. I got my subtraction in the end length wrong.
Code is now:
(DT_STR,10,1252)SUBSTRING(AllOtherData,382,FINDSTRING(AllOtherData,"~",3) - 382)
May 31, 2012 at 11:18 am
There is no guarantee this would be faster, but try a WHILE loop (using your records as a decrementing counter) and see if that has any better performance than a...
May 31, 2012 at 8:04 am
Sean Lange (5/31/2012)
May 31, 2012 at 8:01 am
SKYBVI (5/30/2012)
Brandie Tarvin (5/30/2012)
SKYBVI (5/25/2012)
I have been studying SQL Server DBA interview questions from the net and find these questions in wich I am unclear of...
May 31, 2012 at 4:23 am
just_myles (5/30/2012)
ooohh instrumental, detrimental, potato, potatoe 🙂
Hee.
Anyway I do have a bunch of questions though.
So ask. @=)
If they're related to the article, ask here. If they're related to general job...
May 31, 2012 at 4:14 am
I don't know if this will work on any MS Access past version 2003, but try changing your MS Access front end into an .adp instead of an actually database....
May 30, 2012 at 12:31 pm
L' Eomot Inversé (5/30/2012)
GilaMonster (5/30/2012)
Too snarky?http://www.sqlservercentral.com/Forums/Topic1306465-334-1.aspx
No. If he can't read what he's been referred to he's beyond help. Just giving him the answers wouldn't be useful.
Well, I...
May 30, 2012 at 12:18 pm
Viewing 15 posts - 4,351 through 4,365 (of 9,722 total)