Viewing 15 posts - 1 through 15 (of 229 total)
I don't know, scanning duff code in qotd for the sake of it? You'd probably just as likely find that the output would be ordered.
selectReplace( convert(varchar,
CAST( CAST(a AS VARCHAR(8))...
October 31, 2013 at 10:19 am
Good article.
Paul White (9/9/2013)
dwain.c - Article body
September 9, 2013 at 10:08 am
shouldve couldve...
call me skeptical but i always thought a pms job was to whip you as hard as they could and grab all the glory...
September 29, 2010 at 8:35 am
Jeez, this thread still going. I wonder if one had to search for '%this thread still going%' if this thread would return the highest count...
September 29, 2010 at 8:25 am
DBA in CR (6/26/2009)
...network blip...
Good thought, we normally get the ubiquitously descriptive "General Network Error" when that happens.
Ah, I've got it! Search your code for:
WAITFOR DELAY '100:00:00'
:hehe:
A slightly more professional...
June 26, 2009 at 11:36 am
In your original post you mention that the step that executes the SSIS package is not initiated from the job, how have you managed to determine this i.e. are you...
June 20, 2009 at 3:47 pm
I think we'll probably need some more information if we're going to be able to help. Any more information about the job and underlying tasks would help.
June 17, 2009 at 11:09 am
LiteSpeed appears to have, um, quirks - just a another avenue to investigate as earlier versions caused jobs to hang when backing up to a network drive if I remember...
June 12, 2009 at 8:52 pm
From you op, it appears that Litespeed is involved in the process. Have you checked the Litespeed vendor documentation or contacted them?
June 11, 2009 at 7:31 pm
RBarryYoung (6/1/2009)
Hmm. Nice catch Gianluca.
No pun intended, right Barry? 😉
Erlands' study reminds me of constructing sql statments in VBA before ADO based on user parameters and the ever increasing...
June 1, 2009 at 5:12 pm
RBarryYoung (5/27/2009)
Max (5/27/2009)
...
GilaMonster (5/27/2009)
In 2005, no matter now much you recompile a 'catch-all'...
May 29, 2009 at 6:28 am
Chad Crawford (5/28/2009)
Max (5/28/2009)
Edit: Chad you make me want me have Kitt as my avatarAhhhhh.... someone who knows both their aircraft and their cars! 😀
Yeah, something about midnight-black, shiny and...
May 29, 2009 at 6:26 am
see above for sore losers 😛
been there to - them questions be scurvy, argh
the be question real should: "it why ivarchar isn't?" like I[/b]nternational
Edit: Chad you make me want...
May 28, 2009 at 10:18 am
TheSQLGuru (5/27/2009)
May 27, 2009 at 6:57 pm
Greetings all
A couple of thoughts:
1.
Gianluca Sartori (5/20/2009)
DECLARE @tmpTab TABLE (
column1 int,
column2 int
)
declare @param1 int
declare @result int
set @param1 =...
May 27, 2009 at 8:51 am
Viewing 15 posts - 1 through 15 (of 229 total)