Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 5,502 total)

  • RE: Stump on why this statement ever performs well 1 day 5 minutes next day a second.

    TheSQLGuru (1/26/2011)

    LutzM (1/26/2011)

    It looks like you posted the estimated execution plan.

    Would it be possible to post the actual execution plan?

    Also, would you please post the actual execution of a query...


    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]

    January 26, 2011 at 2:28 pm

    #1278799

  • RE: Are the posted questions getting worse?

    Changing the subject for a moment:

    I also noticed a change in Joe Celkos replies. Here's a reply I have no problem with pointing others to if they're interested in knowing...


    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]

    January 26, 2011 at 1:56 pm

    #1278778

  • RE: Difference between AND & WHERE IN a QUERY ---- PLz reply

    @joe:

    Thank you for the detailed explanation without the "overhead" that triggered some of us to complain about from time to time. This post is of the kind I would...


    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]

    January 26, 2011 at 1:51 pm

    #1278771

  • RE: Stump on why this statement ever performs well 1 day 5 minutes next day a second.

    It looks like you posted the estimated execution plan.

    Would it be possible to post the actual execution plan?

    Also, would you please post the actual execution of a query that performs...


    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]

    January 26, 2011 at 10:04 am

    #1278589

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/26/2011)

    ...

    Funny. I always thought that Hubbard had written Scientology related books. Looks like this one is focused on other topics.

    Why do you think there's a difference?


    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]

    January 26, 2011 at 9:43 am

    #1278572

  • RE: multiple updates

    Please read and follow the advice given in the first link referenced in my signature.

    Like I said in my previous post: the data you provided earlier don't match.

    Example:

    How do you...


    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]

    January 26, 2011 at 9:18 am

    #1278545

  • RE: Flat file to Excel destination!

    I'm not sure if I'm missing the point here, but wouldn't it be easier to use an Excel-Macro for it?

    It just makes me wonder why to use SSIS to convert...


    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]

    January 25, 2011 at 4:08 pm

    #1278237

  • RE: Performance difference between different users calling the same stored procedure?

    I noticed the major difference between the two user types is the additional query against tblYY. (ANDtblX.Div IN (SELECT FieldId FROM tblYY WHERE HRG='''+@EmpId+''') ).

    Unfortunately, it seems like all...


    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]

    January 25, 2011 at 3:45 pm

    #1278234

  • RE: Are the posted questions getting worse?

    GSquared (1/25/2011)

    ...

    A person in a high emotional tone will respond faster than a person in a low one.

    ...

    That's interesting!

    I'm actually known to reply almost instantly to such questions. Most of...


    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]

    January 25, 2011 at 2:46 pm

    #1278207

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (1/25/2011)

    Any volunteers to read through a draft of an article for me ?

    Thanks....

    Sure, if I can be of any help...


    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]

    January 25, 2011 at 2:37 pm

    #1278201

  • RE: Get data from a string

    If you need to separate the string based on a specific set of character (e.g. '_I_') you should look into PATINDEX and '% I %' instead of CHARINDEX...


    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]

    January 25, 2011 at 2:18 pm

    #1278188

  • RE: Sharing Code

    Copy code snippets for internal reuse (with or without modification) is absolutely fine with me (I usually add the web page where I found it). Otherwise I still wouldn't use...


    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]

    January 25, 2011 at 2:10 pm

    #1278183

  • RE: Are the posted questions getting worse?

    Craig Farrell (1/25/2011)

    GSquared (1/25/2011)

    And that's almost certainly more than anyone here wants to know about this subject. :w00t:

    ... listens enraptured. "Not really, that's damnably interesting, actually."

    Agreed. Keep on!

    To answer...


    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]

    January 25, 2011 at 1:53 pm

    #1278175

  • RE: Get data from a string

    It depends.

    If the date is always at the same position, you could use SUBSTRING to eliminate it. Otherwise you'd need to find the pipe character and move left.

    As a side...


    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]

    January 25, 2011 at 1:44 pm

    #1278172

  • RE: Are the posted questions getting worse?

    Craig Farrell (1/25/2011)

    LutzM (1/25/2011)

    GilaMonster (1/25/2011)

    ...

    Bing maps are off then. It's just under 7500km from Johannesburg to Algier (http://www.wolframalpha.com/input/?i=what+is+the+distance+from+Johannesburg+to+Algier)

    When using the same tool: London sounds much more reasonable 😉

    Side note: interesting...


    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]

    January 25, 2011 at 1:15 pm

    #1278148

Viewing 15 posts - 2,011 through 2,025 (of 5,502 total)