Forum Replies Created

Viewing 15 posts - 4,786 through 4,800 (of 5,502 total)

  • RE: row as column

    Please see the links in my signature regarding Croos Tab and Dynamic Cross tab.

    If you need further assistance please provide sample data in a ready to use format as described...


    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]

    November 13, 2009 at 3:55 am

    #1078802

  • RE: How to Prevent DBA's from viewing the data

    Another option would be: get DBA's you trust.

    The DBA job is mostly "underestimated" in terms of the requirements a person in such a position need to meet.

    And one of those...


    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]

    November 13, 2009 at 3:48 am

    #1078800

  • RE: transpose rows into columns

    Jeff Moden (11/12/2009)

    Heh... take a look, Lutz. The person who provided the data isn't even the OP. 😀 I'm out of here.

    @lcarrethers: I'm sorry!! :blush: Didn't notice that...


    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]

    November 13, 2009 at 3:20 am

    #1078784

  • RE: Retrieving the Previous row value to update in the current row

    You might want to have a look at the following link:

    http://www.sqlservercentral.com/articles/T-SQL/68467/

    I think it has all the information to resolve the task you ask for.

    If you don't feel confident using 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]

    November 13, 2009 at 3:07 am

    #1078772

  • RE: error when trying to change scale of decimal data type

    DBA-640728 (11/12/2009)

    thanks for you answer:

    yes it works, but it has to be (11,6),

    conflicts with

    DBA-640728 (11/12/2009)

    yes i do have two values greater than 99999.99

    DECIMAL(11,6) will result in...


    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]

    November 12, 2009 at 4:22 pm

    #1078644

  • RE: Conditional Group by?

    Supriya.S (11/12/2009)

    Anyway I was wondering if you can please explain why my "Exists approach" will be behind in terms of IO, CPU and execution time. Will adding a non-clustered...


    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]

    November 12, 2009 at 3:51 pm

    #1078637

  • RE: Conditional Group by?

    Here's another solution based on ROW_NUMBER.

    It covers the issue of having code is null and location is not null.

    Comparing the two row_number solutions will result in almost identical execution...


    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]

    November 12, 2009 at 2:17 pm

    #1078606

  • RE: transpose rows into columns

    It seems like you couldn't find the time to see, read, understand, and follow the article in the link in Jeffs signature...

    [SET SARCASM ON]

    Maybe it's easier if you follow 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]

    November 12, 2009 at 12:48 pm

    #1078549

  • RE: SQL problem -- need help

    One thing up front:

    Your table definition for @tTrip is not normalized.

    I strongly recommend to consider changing the structure to have only one DrID column and myabe an addtl. column 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]

    November 12, 2009 at 10:04 am

    #1078458

  • RE: horizontalTo vertical Columns

    Glad I could help and sorry it took that long to figure out what you've been 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]

    November 12, 2009 at 12:43 am

    #1078189

  • RE: Performance problems with (unnecessary) nested stored procedures

    J-F Bergeron (11/11/2009)

    Let's try it with a covering index:

    Try to create a nonclustered index on CxToken, CxStatus that includes EcxLastTime (included column). ...

    @ J-F: Just a side note: This...


    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]

    November 11, 2009 at 3:54 pm

    #1078107

  • RE: Performance problems with (unnecessary) nested stored procedures

    ... still trying the second path ... (reducing the number of calls)

    Would the structure of your procedures (especially in terms of number and type of parameter per proc) allow 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]

    November 11, 2009 at 3:35 pm

    #1078097

  • RE: Avoiding Dynamic SQL - How to Re-Write This ?

    Please have a look at one of Gails great articles:

    catch-all-queries[/url]

    The article describes several options, analyzing pros and cons.


    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]

    November 11, 2009 at 2:59 pm

    #1078072

  • RE: Combining Update Statements

    homebrew01 (11/11/2009)

    The original post is much easier to understand. Consider someone looking at or modifying the code a year from now, and the risk of introducing bugs or errors. ...


    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]

    November 11, 2009 at 2:53 pm

    #1078067

  • RE: Performance problems with (unnecessary) nested stored procedures

    What is the root cause to have the validation implemented in almost every proc?

    As far as I can see, there should be room for improvement in terms of the frequency...


    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]

    November 11, 2009 at 2:24 pm

    #1078042

Viewing 15 posts - 4,786 through 4,800 (of 5,502 total)