Viewing 15 posts - 16 through 30 (of 31 total)
At a guess, I would say that WinSCP is prompting for a password it never receives.
How are you logging into your target SFTP server? Are you using its in-built...
July 8, 2013 at 5:57 am
tl;dr - I can't see the point in Service Broker; it doesn't appear to do what it says on the tin and is too convoluted to use...
_________________
On the surface, it...
January 16, 2013 at 9:27 am
I'm not sure why you need the * here.
* is supposed to be a prefixing term, so "ipad*" should match words that start with "ipad", e.g. "ipady", "ipadness", "ipadable" (none...
December 3, 2012 at 8:30 am
Bennett Scharf (11/27/2012)
This is great - especially the idea of baselining your configuration data!
On a related note, I log and analyze my performance counters through Performance Monitor, mainly...
November 30, 2012 at 7:51 am
Theo Ekelmans (11/13/2012)
The project i'm working on is a roof of concept SNMP MIB database, that is so fast it can do (near)realtime SNMP data packet...
November 22, 2012 at 12:26 pm
Michael Meierruth (11/13/2012)
What is this '(select null)' trick all about?
It's a trick to 'order' by constant value, i.e. to not order/sort at all; in this case it adds a row...
November 13, 2012 at 3:56 pm
You're welcome. Make sure you test this on a sample dataset with a large number of rows, though, just to make sure we haven't introduced a performance time-bomb!
Using a...
April 17, 2012 at 8:33 am
WITH
cte_remove AS (
SELECT b.*
FROM dbo.ExampleLog a
INNER JOIN dbo.ExampleLog b ON
a.ID != b.ID AND
a.DISPLAYID = b.DISPLAYID AND
a.OBJECTID = b.OBJECTID AND
b.TIMESTAMP BETWEEN a.TIMESTAMP AND DATEADD(SECOND, 300, a.TIMESTAMP)
),
cte_results AS (
SELECT...
April 16, 2012 at 1:05 pm
I agree with the others and add that you shouldn't need/want to do this is in a well-designed database, but that's not going to make your requirement go away (nor...
March 26, 2012 at 4:03 am
I might be way off base here -- and I don't wish to downplay any of the work you have presented -- but how is this significantly different from the...
January 26, 2012 at 5:33 am
Something inside me really wanted to hate this technique, but I know it has its uses in a pure "staging" environment (i.e. one where you have already committed to do...
January 10, 2012 at 4:47 am
Lesson 17:
Never use MessageBox.Show in the course of your automated ETL process. It blocks operation of the remaining code until a button is pressed. Instead, favour logging to...
December 12, 2011 at 5:30 am
ScottPletcher(11/21/2011)
Interesting code.
But can't use just do either of these:
Looks like you and I had the same idea...
To answer my own question, I found that integer division was a bit of...
November 21, 2011 at 11:15 am
Interesting stuff.
Performance-wise, how does fn_reverse_charIndex hold up against (LEN(@expr) - CHARINDEX(@char, REVERSE(@expr)) + 1)
And, seeing as your fn_simplemath function appears only to handle one expression at a time, how would...
November 21, 2011 at 6:31 am
I might be fuelling the fire here, as I'm merely playing devil's advocate rather than agreeing wholeheartedly with the approach...
But, for the people who say that the DBAs/analysts should be...
February 11, 2011 at 11:44 am
Viewing 15 posts - 16 through 30 (of 31 total)