Forum Replies Created

Viewing 15 posts - 4,591 through 4,605 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (1/5/2010)

    ...

    And now on SQLTeam as well: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137926 Just in case.

    Oh, it was posted 3 weeks ago there too. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137201

    With lots of assistance from lots of people.

    It seems like Gus...


    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 5, 2010 at 2:21 pm

    #1099244

  • RE: Join / union 2 tables with SOME distinct columns

    That's a slightly different requirement...

    What I would do is to start with a calendar table holding days and hours.

    Then I would use this table in a left join on Watts_Hour...


    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 5, 2010 at 1:53 pm

    #1099232

  • RE: Running totals problem

    It seems like the time to find the root cause of poor performance and the "fix" was well spent!

    Glad I could 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 5, 2010 at 1:40 pm

    #1099217

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/5/2010)

    Lynn Pettis (1/5/2010)

    CirquedeSQLeil (1/5/2010)

    Lynn Pettis (1/5/2010)

    CirquedeSQLeil (1/5/2010)

    ...

    Actually, nothing earlier indicated that it was urgent, so more like ...

    I have a problem:

    http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx

    And then, three weeks later, I am going...


    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 5, 2010 at 1:32 pm

    #1099210

  • RE: Running totals problem

    kramaswamy (1/5/2010)

    Oh, neat. So I can do this instead:

    ...

    To have it use "url" as the root, instead of having no root. Nice!

    Yeap.

    It's the same like it is for 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]

    January 5, 2010 at 1:16 pm

    #1099196

  • RE: Running totals problem

    kramaswamy (1/5/2010)

    Wow - that works amazingly well! Took a 45 minute operation down to 5 seconds!

    Can you explain to me how this is working? I'm a bit fuzzy on 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]

    January 5, 2010 at 11:57 am

    #1099133

  • RE: Running totals problem

    kramaswamy (1/5/2010)

    Actually, the size of the string is about that, yes. Some of the larger subsets have over 1 million characters in them.

    So, yeah, they are storing a ton 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 5, 2010 at 10:46 am

    #1099085

  • RE: Join / union 2 tables with SOME distinct columns

    It seems like we need the OP to clarify what he's looking for...


    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 5, 2010 at 10:27 am

    #1099073

  • RE: Join / union 2 tables with SOME distinct columns

    If UNION will be used, there wouldn't be any difference whether it took the data from table 1 or table 2: both have to be identical. How would you know...


    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 5, 2010 at 7:18 am

    #1098935

  • RE: Select Where Any Column Equals (or Like) Value

    dbuendiab (1/5/2010)

    I think you have already several good answers, or at last the kind I would have suggested before this one. Despite of this, and only as a alternative to...


    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 5, 2010 at 4:16 am

    #1098842

  • RE: looking for alternative way to write this query

    winston Smith (1/5/2010)

    ... as there are strict rules about changes that go into production and how they have to go through Test systems first, so they are also included...


    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 5, 2010 at 4:02 am

    #1098834

  • RE: looking for alternative way to write this query

    Do you have an index on your table that is comparable to the one I would use?

    And if so, are the timings taken before or after applying the index?

    Important 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 5, 2010 at 3:30 am

    #1098825

  • RE: how use oderby with different columns

    What have you tried so far?

    Did you check the examples in BOL (Books Online, the SQL Server help system installed together with SQL Server)?

    You might want to look for "Sorting...


    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 5, 2010 at 3:08 am

    #1098815

  • RE: Running totals problem

    @john-2:

    I expect string concatenation as well, based on OPs statement

    My strings, though, can be up to 50-100 characters long, and the database just doesn't seem to be able to...


    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 5, 2010 at 3:05 am

    #1098810

  • RE: XML Query returns zero Records

    Glad I could 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 5, 2010 at 1:29 am

    #1098790

Viewing 15 posts - 4,591 through 4,605 (of 5,502 total)