Forum Replies Created

Viewing 15 posts - 976 through 990 (of 5,502 total)

  • RE: Advice on running totals using a cursor

    Step 1: get the c.u.r.s.o.r. *cough* approach out of your head.

    Step 2: get the relevant max values off the "big table".

    Step 3: perform the running total on the 10k rows...


    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]

    September 13, 2011 at 2:20 pm

    #1380914

  • RE: Transform rows in columns

    virgilrucsandescu (9/13/2011)

    I agree it is probably the most weird request ever, it is a request from a client ...

    They need one Excel column for each row in the dataset, 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]

    September 13, 2011 at 1:18 pm

    #1380896

  • RE: Transform rows in columns

    Please have a look at the CrossTab article referenced in my signature.

    Even though it has a MAX() aggregation in there, it still provide the results you're looking for.... Don't be...


    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]

    September 13, 2011 at 7:04 am

    #1380587

  • RE: Datetime

    change authorised_date <='2011-05-31' to authorised_date <'2011-06-01'


    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]

    September 13, 2011 at 6:43 am

    #1380570

  • RE: Display Column Name verticly

    From my point of view the expected output doesn't match the original data:

    In the original data there's one update capture missing where Test changed to Test1. Also, ActionTime is 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]

    September 13, 2011 at 6:41 am

    #1380569

  • RE: "Broker Transaction Rollbacks" Performance Counter

    Thank you for the feedback.

    I'm not sure if we're just "chasing the wind" here since I'm observing exactly the same (everything runs fine except the number increase).

    If neither one of...


    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]

    September 13, 2011 at 4:03 am

    #1380477

  • RE: "Broker Transaction Rollbacks" Performance Counter

    Hi Nils,

    thank you for your prompt reply!

    Unfortunately, there's no transaction involved (neither in the SEND nor the RECEIVE block).

    The concept is based on Rusanu's reusing-conversations script (link in the SQL...


    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]

    September 12, 2011 at 8:46 am

    #1380080

  • RE: Currency conversion calculation

    Duplicate post. Already answered here


    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]

    September 11, 2011 at 3:03 am

    #1379671

  • RE: simple sp

    I guess Jeff asked to decide whether a CrossTab or a DynamicCrossTab would be required.

    Both concepts are described in the related links in my signature. Disclaimer: Jeff is the 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]

    September 11, 2011 at 2:48 am

    #1379670

  • RE: Table size... need to reduce but how?

    How did you measure those numbers? It's unlikely a single table can be larger than the whole DB (unless there are different filegroups and not all have been taken 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]

    September 10, 2011 at 1:41 pm

    #1379625

  • RE: Questioning virtualization

    Kevin Dahl (9/10/2011)

    ...

    All indications so far are that our new infrastructure/schema/app layers are all performing worse than what they're meant to replace, and the big glaring elephant in the room,...


    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]

    September 10, 2011 at 1:34 pm

    #1379624

  • RE: add a column and if else the select statement?

    Is this all possible within one sql statement and is it the most efficient way of doing this?

    It depends what you're looking for: if it's only a SELECT statement, then...


    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]

    September 10, 2011 at 2:28 am

    #1379575

  • RE: Questioning virtualization

    can virtualizing the DB enable us to cut our CPU power by a factor of 6?

    No and yes.

    Virtualization cannot cut the absolute CPU power an application requires. But it can...


    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]

    September 10, 2011 at 2:22 am

    #1379574

  • RE: Priority based selection from SQL JOIN

    The answer is Zero. 😀

    First part:

    I have to select all the fields that are not NULL from T3.

    Except the fact that we don't really have "fields" (that's more 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]

    September 10, 2011 at 2:07 am

    #1379571

  • RE: count() or group by or nested select?

    Something like this?

    select patient.dbpatcnt as id,

    COUNT(*) as cnt,

    COUNT(patient.dbpatcnt) OVER (PARTITION BY...


    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]

    September 10, 2011 at 1:58 am

    #1379569

Viewing 15 posts - 976 through 990 (of 5,502 total)