Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 5,502 total)

  • RE: Pivot query to use returned value as first row.

    Do you want to have the result set as one column with separator or do you want one column per date?

    Edit: and why do you need to do it on...


    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 10, 2010 at 12:11 pm

    #1178838

  • RE: XQuery Returns Null

    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]

    June 10, 2010 at 10:40 am

    #1178755

  • RE: XQuery Returns Null

    Two minor fixes: 1) remove the namespace declaration since this is an untyped xml document and 2) remove the "/PROVIDER" from your nodes declaration since this tag is closed before.

    --;WITH...


    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 10, 2010 at 9:41 am

    #1178698

  • RE: Performance: INSERTing records into "large" tables.

    mzak (6/8/2010)

    ...

    External environment aside...

    If you're concerned about INSERT performance only, adding indexes will cause more writes to occur which has the potential to slow down INSERTs (depends on if 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]

    June 8, 2010 at 3:19 pm

    #1177698

  • RE: Selecting the earliest month wrapping January to December

    To follow tosscrosby's concern:

    What would be your expected output for the following sample data? And Why?

    INSERT @Sample (PersonID, Month) VALUES (11,'06');

    INSERT @Sample (PersonID, Month) VALUES (11,'08');

    INSERT @Sample...


    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 8, 2010 at 2:49 pm

    #1177687

  • RE: Optimizing Query with aggregate function and case statement

    I probably would use a CTE to calculate the sum using a case condition like you did. I think the execution plan will be the same but it's easier 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]

    June 8, 2010 at 1:40 pm

    #1177655

  • RE: Data format

    You could use the FOR XML PATH string concatenation.

    For a list of examples, please search this site for "string concatenation xml".

    Side note: with 90 visits I'd expect you did run...


    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 8, 2010 at 1:33 pm

    #1177654

  • RE: How to query a one-to-many and only return 1 row on many side

    and here's the same approach, just without using intermediate tables (I'm using subqueries, or CTE's):

    Side note (valid for both solutions provided so far): Those solution will only work if 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]

    June 7, 2010 at 3:10 pm

    #1177234

  • RE: Very Urgent Help Needed related to security

    But whatever you do, keep in mind that someone with sa privileges might still be able to change permissions without leaving a trace (or at least with a trace that's...


    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 7, 2010 at 12:45 pm

    #1177202

  • RE: How to tune/speed up a procedure

    Thank you for clarification, Gregory! (I shuddered for a moment or two... :hehe: )

    Glad it did save "a minute or two" 😀

    It was a real pleasure working with you. Come...


    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 7, 2010 at 12:12 pm

    #1177184

  • RE: How to tune/speed up a procedure

    gregory.anderson (6/7/2010)

    Funny you just asked, Lutz. Had the conversion on Saturday. Ran in 1:48. Then entire process KILLED my previous times since I was running on some really beefy servers....


    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 7, 2010 at 11:58 am

    #1177175

  • RE: How to tune/speed up a procedure

    Hi Gregory,

    any news regarding the performance on the production hardware?


    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 6, 2010 at 4:28 pm

    #1176903

  • RE: Collapsing a Table

    @jeff: I'm confused...

    When talking about the double row_number approach I was referring to the sample code I provided a few posts back (not the "deep dive" approach though).

    It's showing 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 6, 2010 at 3:54 pm

    #1176898

  • RE: Update statement with multiple tables

    Would you please clarify your requirement?

    Are all those elements in your list columns, tables or something else?

    Do you really have two columns [updateflat] and [updateflag] or is it a typo...


    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 6, 2010 at 12:41 pm

    #1176876

  • RE: Collapsing a Table

    Jeff, are you saying a c.u.r.s.o.r. should be preferred instead of the "double-row-number" approach??


    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 6, 2010 at 10:37 am

    #1176867

Viewing 15 posts - 3,346 through 3,360 (of 5,502 total)