Forum Replies Created

Viewing 15 posts - 5,176 through 5,190 (of 5,502 total)

  • RE: How to transpose from Row to Columns with out using Pivot

    What makes me wondering though is what Chris (the OP who started this thread in the first place) ended up with to tune his query... The subject he was talking...


    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]

    June 28, 2009 at 5:13 am

    #1016500

  • RE: How to transpose from Row to Columns with out using Pivot

    Paul White (6/28/2009)

    lmu92 (6/28/2009)

    Paul White (6/27/2009)

    Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods. ...

    Paul

    But how about the method I posted...


    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]

    June 28, 2009 at 4:44 am

    #1016497

  • RE: How to transpose from Row to Columns with out using Pivot

    Paul White (6/28/2009)

    ... Well yes - but then we aren't comparing apples with apples anymore. Your method is specifically optimized for the data distribution you set up - and...


    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]

    June 28, 2009 at 4:32 am

    #1016495

  • RE: How to transpose from Row to Columns with out using Pivot

    Paul White (6/27/2009)

    Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods. ...

    Paul

    But how about the method I posted above (let's call...


    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]

    June 28, 2009 at 2:25 am

    #1016483

  • RE: Split string using XML

    I just ran across one of J. Sebastians article on how to do a string split using XML:http://www.sqlservercentral.com/articles/XML/61618/. Looks comparable...


    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]

    June 27, 2009 at 4:30 pm

    #1016451

  • RE: Trasitive dependencies

    smsam1 (6/27/2009)

    i know that this table is not is 3NF, since 'has_passed' depends on 'marks'. is it the same as saying in the second sentence

    I'm not sure where you get...


    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]

    June 27, 2009 at 3:32 pm

    #1016447

  • RE: Are the posted questions getting worse?

    @Flo:

    I always enjoy to watch two Germans arguing about an english statement made by one of them... - especially if I'm directly involved... 😀 I'm not sure whether I...


    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]

    June 27, 2009 at 3:01 pm

    #1016441

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/26/2009)

    Florian Reischl (6/26/2009)

    ...

    @jeff

    Just saw your post here

    Maybe you missed this post by Lutz. There is a case where PIVOT seems to be much faster than cross-tab here.

    Not if...


    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]

    June 27, 2009 at 11:43 am

    #1016424

  • RE: How to transpose from Row to Columns with out using Pivot

    Hi Paul,

    thanx for the test scenario!

    When I ran your scenario (1 mill rows, 333333 client id's) on my laptop I got approx. 1.1sec for all three versions (CASE, aggregate and...


    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]

    June 27, 2009 at 10:04 am

    #1016413

  • RE: How to transpose from Row to Columns with out using Pivot

    Hi Chris,

    first of all thank you for taking the time to get the data together and post it here!

    Great job! :Wow:

    When looking at the numbers in your table I started...


    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]

    June 25, 2009 at 5:06 pm

    #1015693

  • RE: Parsing XML file to import data into SQL 2008

    Now it's starting to get a little less cloudy...

    The question is: Why would you try to save an Excel file using xml just to be able to import it into...


    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]

    June 25, 2009 at 4:34 pm

    #1015684

  • RE: Parsing XML file to import data into SQL 2008

    Please read and follow the advice I refer to in my signature. It's still not clear what you're looking for. Please provide usable sample data.

    Btw: I did see your original...


    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]

    June 25, 2009 at 3:12 pm

    #1015648

  • RE: Text File Input to a Query

    That's one of the OP's responsibilities: To tell us what he/she is looking for...

    You're right though, it's not obvious yet.


    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]

    June 25, 2009 at 2:33 pm

    #1015605

  • RE: Text File Input to a Query

    Please have a look at BOL, "OPENROWSET function" -> OPENROWSET (Transact-SQL)

    Example right out of BOL:

    SELECT a.* FROM OPENROWSET( BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a;


    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]

    June 25, 2009 at 2:16 pm

    #1015594

  • RE: Parsing XML file to import data into SQL 2008

    It's a little bit confusing to me what you're trying to achieve...

    What I figured is that you want to import xml structure from a flat file.

    Right after that I'm lost:...


    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]

    June 25, 2009 at 2:09 pm

    #1015590

Viewing 15 posts - 5,176 through 5,190 (of 5,502 total)