Forum Replies Created

Viewing 15 posts - 4,126 through 4,140 (of 5,502 total)

  • RE: which query's exec. costs are better/more efficient

    RBarryYoung (3/2/2010)

    ...

    First, I am convinced that this is just too big to fit into a Forum post. Secondly, I realize that we have sort of hijacked the OPs thread...


    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]

    March 2, 2010 at 12:34 pm

    #1127349

  • RE: Split one field into multiple using a delimiter

    david.pelizzari (3/2/2010)

    lmu92 (3/2/2010)

    You should look for split string functions on this site.

    There are numerous solutions available.

    One pretty fast solution is described at the end of the Tally Table article referenced...


    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]

    March 2, 2010 at 11:24 am

    #1127309

  • RE: Loading XML into SQL via XML Loader Tool

    RBarryYoung (3/2/2010)

    whoa! Did you know that this is embedding subordinate elements inside of text content? I'm not even sure if that's valid XML...

    To me it looks more likt...


    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]

    March 2, 2010 at 10:17 am

    #1127251

  • RE: Split one field into multiple using a delimiter

    Hunterwood (3/2/2010)

    Here is one way to solve the problem:

    declare @str varchar(200)

    set @str = 'Apple, Banana,Orange, Pinapple, Lemon'

    declare @result table (string varchar(100))

    declare @start int

    declare @end int

    set @start = 1

    set @end =...


    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]

    March 2, 2010 at 10:11 am

    #1127245

  • RE: Split one field into multiple using a delimiter

    You should look for split string functions on this site.

    There are numerous solutions available.

    One pretty fast solution is described at the end of the Tally Table article referenced in my...


    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]

    March 2, 2010 at 8:35 am

    #1127140

  • RE: Performance issue with query

    Yatish,

    is there any specific reason for reposting the same question that can be found here ??

    Not only that you split answers across multiple threads, you'll also have several people...


    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]

    March 2, 2010 at 3:47 am

    #1126937

  • RE: Long runing query

    The two query plans are not identical.

    The slow plan is actually processing 2.509.700.160 (2 and a half billion!) rows from tempdb.dbo.#revdates (estimated: 454080). See the thick arrow on the left...


    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]

    March 1, 2010 at 5:11 pm

    #1126786

  • RE: which query's exec. costs are better/more efficient

    Jeff Moden (3/1/2010)

    ...

    I know you know this, Lutz... just saying this in case anyone thinks otherwise....

    Don't rely on the execution plan for differenences in performance either. Sure, 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]

    March 1, 2010 at 5:00 pm

    #1126782

  • RE: Long runing query

    Actual (not estimated) execution plan. saved as .sqlplan and attached to your post would help a lot.


    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]

    March 1, 2010 at 2:41 pm

    #1126725

  • RE: Are the posted questions getting worse?

    GilaMonster (3/1/2010)

    So, which games are you going to be attending?

    I hope they'll set up those great public viewing areas again like they did in 2006 over here in Germany....


    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]

    March 1, 2010 at 1:22 pm

    #1126672

  • RE: which query's exec. costs are better/more efficient

    I just stumbled across that Simple Talk article .

    I found it very interesting and descriptive. To me the most important message is to not only rely on the results...


    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]

    March 1, 2010 at 11:23 am

    #1126602

  • RE: continue running job if error occur

    Mad-Dog (3/1/2010)

    Hi,

    try an catch is the only way to allow the proc to continue to run even if he have an error?

    THX

    Well, you could setup each step of your proc...


    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]

    March 1, 2010 at 10:01 am

    #1126545

  • RE: Are the posted questions getting worse?

    Paul White (3/1/2010)

    I was labouring under a misapprehension as far as the Olympics were concerned: I had always thought that the country with the highest number of Gold Medals came...


    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]

    March 1, 2010 at 9:49 am

    #1126536

  • RE: XML Parse Query

    Paul White (2/28/2010)

    lmu92 (2/28/2010)

    ...

    Unless you are processing huge XML data sets, I really don't think it matters too much. If you were processing huge sets of XML data...


    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]

    March 1, 2010 at 3:51 am

    #1126405

  • RE: continue running job if error occur

    Did you try to wrap your code into TRY ... CATCH blocks?

    That would give you the option to control the "behavior" of a proc.

    If you want to control more 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]

    February 28, 2010 at 4:46 pm

    #1126326

Viewing 15 posts - 4,126 through 4,140 (of 5,502 total)