Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 5,502 total)

  • RE: Using OpenXML

    Is there any specific reason for still using OPENXML over XQuery?

    How about comparing the performance against the following XQuery statement?

    SELECT

    v.value('id[1]','NVARCHAR(256)') AS ID,

    x.value('@href[1]','NVARCHAR(256)') AS [Link],

    x.value('@rel[1]','NVARCHAR(256)') AS [LinkRel],

    z.value('Status[1]','NVARCHAR(256)') AS [Status]

    FROM @document.nodes('entry[1]') T(c)

    CROSS...


    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]

    August 20, 2010 at 3:54 pm

    #1209966

  • RE: get stored procedure to loop through list of variables

    So let's asume the given scenario (no set based solution possible and a unchangeable sproc).

    Do you have any proof of concept available that a while loop would perform better than...


    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]

    August 20, 2010 at 3:38 pm

    #1209959

  • RE: Is it possible to combine the values from more than 1 record into 1 resultset?

    Ok, you did the first stepby providing the DDL script for the table.

    The second step would be to provide some ready to use (fake) sample data (provided as INSERT statements)....


    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]

    August 20, 2010 at 3:25 pm

    #1209953

  • RE: UPDATE question

    Robert Frasca (8/20/2010)

    Forget it. I knew as soon as I asked on this forum I'd see the answer.

    The second column is using the value set for the first column...


    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]

    August 20, 2010 at 3:18 pm

    #1209947

  • RE: get stored procedure to loop through list of variables

    @supachoi:

    Replacing a c.u.r.s.o.r with a while loop due to performance reasons is like suggesting to cure cancer with AIDS.

    Both solutions (loop and cursor) are row based (aka RBAR) won't give...


    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]

    August 20, 2010 at 3:09 pm

    #1209942

  • RE: get stored procedure to loop through list of variables

    Ok, here's an example on how to do it. Howver, I strongly recommend you get the vendor involved providing you a function with the same functionality (iTVF preferred...).

    This would not...


    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]

    August 20, 2010 at 2:07 pm

    #1209920

  • RE: How to read first line of each text file in a folder and validate

    thisisdeepthy (8/20/2010)

    cAN YOU PLEASE ALSO ADD THE SCRIPT WITH THIS TEXT VALIDATION IN THE CURSOR ? AND ALSO SLIGHT CHANGES IN THE REQ, NEED TO MOVE THE VALID FILES 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]

    August 20, 2010 at 1:06 pm

    #1209879

  • RE: SubString Help

    Nice one!


    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]

    August 20, 2010 at 8:23 am

    #1209692

  • RE: How do I get the Last Inserted / Modifed Record

    First thing: there is no such thing like the 5th row.

    The order of rows in a table doesn't really matter. Not even the physical order of rows really is deterministc...


    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]

    August 20, 2010 at 7:07 am

    #1209636

  • RE: Is there any solution for reducing execution time of stored procedure

    There is definitely some room for improvement.

    To test the sample code I would like to have table def (DDL script) including index scipt(s) for the tables involved and some ready...


    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]

    August 20, 2010 at 6:49 am

    #1209626

  • RE: How many rows were inserted?

    Either use @@ROWCOUNT as the immediately following comand after your insert statement or if you'd like to get more details from the values inserted use the OUTPUT clause in 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]

    August 20, 2010 at 6:30 am

    #1209611

  • RE: Using OpenXML

    Having a closer look at your document it seems like there is an inconsistent default namespace declaration:

    < entry xmlns="http://www.w3.org/2005/Atom" >

    < Contact xmlns="http://ws.constantcontact.com/ns/1.0/" >

    Either you set those two elements to 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]

    August 20, 2010 at 5:12 am

    #1209578

  • RE: Help on a simply Query

    If the ClientId column isn't indexed you will end up with a table scan causing bad performance. If you're allowed to, add the ClientId (nonclustered) index and see if it...


    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]

    August 20, 2010 at 4:05 am

    #1209551

  • RE: Using OpenXML

    What is your expected output based on the sample data provided?

    Since you have a named xml doc you need to use the namespace declaration in your query.

    I don't know 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]

    August 20, 2010 at 4:03 am

    #1209550

  • RE: Combine up to several records in single table into one record

    You're welcome!

    That's exactly the attitude that's needed: get an idea/code snippet, do some research, learn how it works and modify it to your needs. Excellent job on your 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]

    August 19, 2010 at 3:57 pm

    #1209407

Viewing 15 posts - 2,956 through 2,970 (of 5,502 total)