Forum Replies Created

Viewing 15 posts - 1 through 15 (of 229 total)

  • RE: DATE Conversion and Format

    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))...

  • RE: A Hazard of Using the SQL Update Statement

    Good article.

    Paul White (9/9/2013)


    dwain.c - Article body


    Since we always hear that SQL does not guarantee row ordering without an explicit ORDER BY clause, we assume that the same case is...

  • RE: Are the posted questions getting worse?

    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...

  • RE: Are the posted questions getting worse?

    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...

  • RE: Job hangs - no error Please suggest

    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...

  • RE: Job hangs - no error Please suggest

    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...

  • RE: Job hangs - no error Please suggest

    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.

  • RE: Job hangs - no error Please suggest

    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...

  • RE: Job hangs - no error Please suggest

    From you op, it appears that Litespeed is involved in the process. Have you checked the Litespeed vendor documentation or contacted them?

  • RE: Query Timeout

    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...

  • RE: Query Timeout

    RBarryYoung (5/27/2009)


    Max (5/27/2009)


    ...

    GilaMonster (5/27/2009)


    Yes it was and yes it it. However, it would make not the slightest bit of difference.

    In 2005, no matter now much you recompile a 'catch-all'...

  • RE: nvarchar

    Chad Crawford (5/28/2009)


    Max (5/28/2009)


    Edit: Chad you make me want me have Kitt as my avatar

    Ahhhhh.... someone who knows both their aircraft and their cars! 😀

    Yeah, something about midnight-black, shiny and...

  • RE: nvarchar

    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...

  • RE: Query Timeout

    TheSQLGuru (5/27/2009)


    Topical and timely words to the wise from Bart Duncan (someone who REALLY knows what is going on with SQL Server) and isn't just a pretender like myself! ...

  • RE: Query Timeout

    Greetings all

    A couple of thoughts:

    1.

    Gianluca Sartori (5/20/2009)


    Now I'm sure that SQLServer uses shortcircuit OR. Try this:

    DECLARE @tmpTab TABLE (

    column1 int,

    column2 int

    )

    declare @param1 int

    declare @result int

    set @param1 =...

Viewing 15 posts - 1 through 15 (of 229 total)