Forum Replies Created

Viewing 15 posts - 28,066 through 28,080 (of 59,101 total)

  • RE: Sql Query - get most recent data and put record numbers into columns

    Guy N (11/26/2012)

    I am not sure exactly how to phrase what I am asking so thanks for looking and I will try to clarify the title if possible.

    Basically, I need...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 8:54 pm

    #1562479

  • RE: Sql Query - get most recent data and put record numbers into columns

    CELKO (11/26/2012)

    You might also want to learn the ANSI row constructor syntax for INSERT INTO:

    INSERT INTO Readmits

    (mr_nbr, birth_date, first_name, last_name, discharge_timestamp)

    VALUES

    ('SHL295834', '1955-09-12', 'JK', 'Aaron', '2011-05-03 20:56:00'),

    ('SMC101149', '1955-09-12', 'JK',...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 8:38 pm

    #1562476

  • RE: Data Import from CSV file

    rhythm.varshney (11/26/2012)

    Phil Parkin (11/26/2012)

    rhythm.varshney (11/26/2012)

    waiting for your valuable input guys........

    You still have not asked a single question - there is nothing to respond to.

    please suggest the way to get the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 8:24 pm

    #1562475

  • RE: self joining a table to get Parent Child relationship

    If the Parent/Child relationship has been checked for "cycles" and there are none, the you might be interested in the following two related articles on a couple of ways to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 7:23 pm

    #1562472

  • RE: SSD Lifetimes

    Michael Valentine Jones (11/26/2012)

    Jeff Moden (11/26/2012)

    Steve Jones - SSC Editor (11/26/2012)

    Jeff Moden (11/26/2012)

    Michael Valentine Jones (11/25/2012)

    I think they quote most mechanical disks with a MTBF of 1 million+ hours. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 1:51 pm

    #1562412

  • RE: rebuild index worsens query performance

    jgenovese (11/26/2012)

    no "divide-and-conquer", etc. until we figure out what happened that weekend

    Unless you can resurrect a Before'n'After of the actual Execution Plan, that could be a very long wait. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 12:21 pm

    #1562365

  • RE: Review Your Indexing

    Steve Jones - SSC Editor (11/26/2012)

    The DTA recommendations shouldn't be taken blindly. I think rookies can use it, but take one change at a time, test it, and see if...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 12:11 pm

    #1562358

  • RE: SSD Lifetimes

    Steve Jones - SSC Editor (11/26/2012)

    Jeff Moden (11/26/2012)

    Michael Valentine Jones (11/25/2012)

    I think they quote most mechanical disks with a MTBF of 1 million+ hours. I have to assume that...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 11:57 am

    #1562348

  • RE: SSD Lifetimes

    Michael Valentine Jones (11/25/2012)[hrHowever, if your application is actually writing 20TB per day, then IO is likely a bottleneck, so it may be worth having a $55,000 10 drive SSD...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 5:45 am

    #1562171

  • RE: SSD Lifetimes

    Michael Valentine Jones (11/25/2012)

    Jeff Moden (11/25/2012)

    FusionIO has listed 2 million hours and 6 years write endurance for their cards, ...

    Perhaps I'm reading something wrong but 6 years is only about...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 4:58 am

    #1562153

  • RE: Backup Overwrite

    To answer your original question, you can overwrite the old file but 1) there would be no timestamp involved and 2) it would render the previous backup useless if anything...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 26, 2012 at 4:53 am

    #1562149

  • RE: SQL IO Performance

    And to think there are DBAs out there that forbid the use of Temp Tables. Divide'n'Conquer comes through again! 🙂

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 25, 2012 at 8:10 am

    #1562048

  • RE: SQL find maximum of table generated with select

    Ironicster (11/25/2012)

    Tks

    Didn't know the WITH yer

    Rgds

    Just to make it easier to find information on the subject, it's the precursor for a thing called "Common Table Expressions" or just "CTE" for...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 25, 2012 at 8:02 am

    #1562046

  • RE: Review Your Indexing

    I'll suggest that DTA isn't for index-rookies. I'm still cleaning up the mess created over 2 years by people just taking DTA's word for which indexes need to be...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 25, 2012 at 8:00 am

    #1562045

  • RE: Backup Overwrite

    sqlquery-101401 (11/24/2012)

    I have a requirement where i need to take daily backup with datetime stamp , the issue is we have limited amount of space to accomodate only one backup...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 25, 2012 at 7:44 am

    #1562044

Viewing 15 posts - 28,066 through 28,080 (of 59,101 total)