Viewing 15 posts - 4,336 through 4,350 (of 9,707 total)
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
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 the solutions :-
1)...
May 30, 2012 at 12:04 pm
In your examples, there isn't a single instance of a summed amount that comes to a decimal total above 50. In normal rounding, anything below 50 rounds down to the...
May 30, 2012 at 10:34 am
Please post the code you are using for calculating these numbers. It helps me if I have a visual of what you're doing.
May 30, 2012 at 9:19 am
Viewing 15 posts - 4,336 through 4,350 (of 9,707 total)