Forum Replies Created

Viewing 15 posts - 19,816 through 19,830 (of 59,098 total)

  • RE: Fine tuning Queries

    Ed Wagner (8/21/2015)

    If you haven't downloaded Grant's book on execution plans, I would do it. It's an excellent book that explains a lot of things and it would give...

    --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)

    August 22, 2015 at 1:18 am

    #1821827

  • RE: Annual Security Compliance Training

    Ed Wagner (8/21/2015)

    It's really too bad if the security training is more about legal garbage than about teaching people how to do things properly. Maybe, just maybe, if it...

    --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)

    August 22, 2015 at 1:11 am

    #1821826

  • RE: Rendering PDFs Natively in SQL

    David Rueter (5/9/2013)

    I'm always amazed at the number of people that blindly cry "scalability" as some sort of a trump card without understanding the requirements first. Scalability is only one...

    --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)

    August 21, 2015 at 5:18 pm

    #1821815

  • RE: Nope to NoOps, No way to NoDBA

    GoofyGuy (8/21/2015)

    The DBA gets to torture and embarrass the app developer. Nothing, but nothing, pleases a DBA more than this.

    Not for me. I absolutely love it when code does...

    --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)

    August 21, 2015 at 5:05 pm

    #1821811

  • RE: Update Statistics & Rebuild index (MaintenancePlan)

    lgluna20 (8/21/2015)

    Hello

    Thanks you very much for your answer

    Sorry in case of the questions number 3 I was not clear about it.

    Basically as you know SQL Server include Maintenance...

    --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)

    August 21, 2015 at 4:55 pm

    #1821810

  • RE: Fine tuning Queries

    For too many reasons to explain here, SQL Server really, really likes NOT NULL, UNIQUE, ever increasing, narrow clustered indexes. A date time column can be very good 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)

    August 21, 2015 at 4:50 pm

    #1821809

  • RE: The Road to Success

    Steve Jones - SSC Editor (8/21/2015)

    This is why I am pushing unit testing. The things that Tom mentions are true. We don't have huge verification budgets, nor time, and mistakes...

    --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)

    August 21, 2015 at 10:05 am

    #1821756

  • RE: Annual Security Compliance Training

    I agree with THAT kind of training. THAT would be very useful. Since I'm a DBA, I'm considered to fall into 5 different training tracks for my company...

    --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)

    August 21, 2015 at 7:11 am

    #1821674

  • RE: Annual Security Compliance Training

    The "training" is ridiculous for some of us. There needs to be two versions... one for people that don't work with security every day and a MUCH shorter version...

    --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)

    August 21, 2015 at 7:03 am

    #1821669

  • RE: handling odd date format

    Good guess.

    --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)

    August 21, 2015 at 6:57 am

    #1821667

  • RE: The Road to Success

    I'll admit that there are mistakes that make it through to production where I work but they are very few, far between, and usually nearly trivial in nature because we...

    --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)

    August 20, 2015 at 6:16 pm

    #1821569

  • RE: Sorting in Powershell

    I guess my question would be... why on Earth are you doing this in PowerShell?

    --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)

    August 20, 2015 at 5:31 pm

    #1821566

  • RE: Fine tuning Queries

    mufadalhaiderster (8/20/2015)

    It would be a good practice for some of you experts.

    Heh... actually, it would be good practice for YOU! 😉 Download Grant Frichey's free book on execution plans...

    --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)

    August 20, 2015 at 5:26 pm

    #1821565

  • RE: The Road to Success

    Iwas Bornready (8/20/2015)

    I just worry about the programmers that want to "fix" something that isn't broken, just to make it more efficient. As often as not they really don't understand...

    --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)

    August 20, 2015 at 1:02 pm

    #1821529

  • RE: forecasting projection--how to approach this?

    dandenise316 (8/20/2015)

    Correct sir, but how to calculate that multiplier?

    I'm interested in finding out what the average responses / applications, etc are based upon the mailer volume and mailer type fields....

    --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)

    August 20, 2015 at 10:52 am

    #1821483

Viewing 15 posts - 19,816 through 19,830 (of 59,098 total)