Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 5,502 total)

  • RE: Where clause

    something like where abc in (5, 6)

    OR (abc in (1, 2, 3, 4) AND cde in (123, 452, 78, 124, 458))


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 2:51 pm

    #1350653

  • RE: Issues in QUEST DISCOVERY WIZARD FOR SQL SERVER

    You might want to try the original QUEST site. There's a FAQ as well as a forum (IIRC).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 2:18 pm

    #1350645

  • RE: Issues in QUEST DISCOVERY WIZARD FOR SQL SERVER

    duplicate post. no replies please.

    original post can be found here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 2:18 pm

    #1350643

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/8/2011)

    WayneS (7/8/2011)

    Steve Jones - SSC Editor (7/8/2011)

    TGIF

    Actually not so much. Leaving for the UK on Sunday, will be out of touch for most of the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 11:39 am

    #1350547

  • RE: Urgent reply Preventing SSIS packages from running across servers when executed

    duplicate post. No replies please.

    Original post can be found here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 11:37 am

    #1350545

  • RE: Help with VERY slow update

    To repeat what I stated earlier:

    It seems like the indexes available can't be used in the first statement since the indexes are not covering indexes (e.g. an index for table2...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 11:02 am

    #1350525

  • RE: Multiple OUTER JOIN query is slow

    but where do I draw the line? 20? 50? 100? Inevitably, someone will want 101 or 102. Putting a firm number seems to me to indicate some real, defined limit....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 10:52 am

    #1350519

  • RE: Best way to insert records

    kramaswamy (7/8/2011)

    you basically thinking something along the lines of

    INSERT INTO TABLE1 (Columns)

    OUTPUT INSERTED.ID INTO #TempTable

    SELECT FROM InputRecordSet

    INSERT INTO TABLE2 (Columns)

    SELECT ID...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 10:22 am

    #1350493

  • RE: Best way to insert records

    Since you're using SS2K5 (as indicated by the forum you posted in) I'd recommend to look into the OUTPUT clause of the INSERT statement. It's much more reliable than the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 8, 2011 at 8:06 am

    #1350370

  • RE: Multiple OUTER JOIN query is slow

    I'd start at the very beginning:

    The massive use of VARCHAR(MAX) seems to be oversized from my point of view. Not only within the functions, but also within the table structure:

    Example:...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 7, 2011 at 1:51 pm

    #1350003

  • RE: How to find count of employee's/count of names of employee's as per first character

    Since this is a rather strange requirement, may I ask if this is ome kind of homework?

    Anyhow, you'll need a table (or subquery or CTE) with all character values you'd...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 7, 2011 at 1:30 pm

    #1349980

  • RE: Help with VERY slow update

    It seems like the indexes available can't be used in the first statement since the indexes are not covering indexes (e.g. an index for table2 should not only include the...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 7, 2011 at 1:05 pm

    #1349957

  • RE: error : subquery returned more than 1 value

    Please post table def for the tables invloved together with some sample data in a ready to use format as described in the first link in my signature.

    Please include your...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 6, 2011 at 2:56 pm

    #1349316

  • RE: Would you change to a better job for a lot less money?

    Dont let the fact that your current job is boring overrule any other criteria you would otherwise use when evaluating a new opprtunity:

    Is the new job closer to your home?

    Any...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 6, 2011 at 2:36 pm

    #1349296

  • RE: error : subquery returned more than 1 value

    The error message usually include a line number to point you in the right direction.

    It can be any of the three updates using a subquery.

    The TOP 1 ORDER BY will...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    July 6, 2011 at 2:29 pm

    #1349294

Viewing 15 posts - 1,306 through 1,320 (of 5,502 total)