Forum Replies Created

Viewing 15 posts - 20,086 through 20,100 (of 59,098 total)

  • RE: Is It Worth Writing Unit Tests?

    David.Poole (7/23/2015)

    In the same way that men shaved without cutting their throats before the invention of safety razors quality code was written before the invention of unit tests.

    Hmmmm.... maybe I'm...

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

    July 23, 2015 at 7:18 pm

    #1814618

  • RE: Is It Worth Writing Unit Tests?

    Ed Elliott (7/23/2015)

    Thank you!

    I guess what I was trying to get across is that it often seems quicker to go and just fix something but it always ends up taking...

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

    July 23, 2015 at 12:37 pm

    #1814518

  • RE: The Evolving DBA

    Considering how many people have asked how to restore data without backups this month alone, this is a timely reminder that evolution of the DBA doesn't remove any responsibilities from...

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

    July 22, 2015 at 9:40 pm

    #1814272

  • RE: array variables in sql server?

    sqlguy-736318 (7/22/2015)

    Hi what are my options for implementing and using array variables in SQL Server? The app I'm currently working on uses SQL Server 2008 so the array implementation...

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

    July 22, 2015 at 3:59 pm

    #1814246

  • RE: Increase ecessivo tempdb

    rmedeiros (7/22/2015)

    Good morning everyone, I have a problem in my SQL and would like a help from you, my tempdb bank in recent weeks is with a ecessivo growth is...

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

    July 22, 2015 at 3:43 pm

    #1814240

  • RE: need to understand the bulk insert

    jghali (7/22/2015)

    Hi all,

    I'm testing a procedure on a combination of different Operating Systems with different versions of SQL express with the same data on all environments.

    Win7 + SQL2014 -->...

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

    July 22, 2015 at 3:34 pm

    #1814239

  • RE: Today's Random Word!

    djj (7/22/2015)

    Ed Wagner (7/22/2015)

    djj (7/22/2015)

    BWFC (7/22/2015)

    Ed Wagner (7/22/2015)

    SQLRNNR (7/21/2015)

    Ed Wagner (7/21/2015)

    ZZartin (7/21/2015)

    SQLRNNR (7/21/2015)

    cow

    Pie

    Apple

    Chunky

    Smooth

    Silk

    Cotton

    Fields

    Back Home

    Back When

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

    July 22, 2015 at 3:09 pm

    #1814236

  • RE: Are the posted questions getting worse?

    BWFC (7/22/2015)

    Aargh!!

    'Why didn't this appear on your report? It's wrong. There's been an incident and you've made us look bad in front of government.' - The Business

    <investigates>

    'It's not...

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

    July 22, 2015 at 3:06 pm

    #1814234

  • RE: Using Decimal Colums in SUM function

    sgmunson (7/22/2015)

    I am rather familiar with what I've always referred to as cumulative error - a result of multiple calculations, each individually limited in precision, such that for accuracy purposes,...

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

    July 22, 2015 at 2:11 pm

    #1814221

  • RE: Using Decimal Colums in SUM function

    sgmunson (7/21/2015)

    devsql123 (7/21/2015)

    Thanks Jayanth for this superb example.

    If all you go by is the example that shows a float data type not having a problem where a rather narrowly defined...

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

    July 21, 2015 at 9:34 pm

    #1813996

  • RE: Indexes with more writes than reads

    lmarkum (7/20/2015)

    Jeff,

    This table does not have any unique indexes. The tables that have a unique non-clustered are few and far between. The table is not partitioned, and neither...

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

    July 21, 2015 at 1:05 pm

    #1813952

  • RE: Presenting Data

    Steve Jones - SSC Editor (7/20/2015)

    dietztm (7/20/2015)

    Why not learn Power Pivot too? It's not THAT hard. I know that many of us are allergic to Excel (from an end-user perspective)...

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

    July 20, 2015 at 5:06 pm

    #1813760

  • RE: Need login help to send files to

    jonathanm 4432 (7/20/2015)

    John,

    Maybe I am doing something wrong with it. I need to copy the files that each section outputs to a server which has a log on and I...

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

    July 20, 2015 at 2:30 pm

    #1813745

  • RE: Numeric/Negative Check

    Naina_11 (7/17/2015)

    Gosh... I am sorry i am not ignoring... i trying to find some simpler way if any else i have your suggestion in store. Looking for something easier as...

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

    July 20, 2015 at 2:26 pm

    #1813743

  • RE: Linked AS400 stopped working

    btjtaylor (7/14/2015)

    I was working on this problem for a client and came across this thread. I experienced the issue when using a 2-node SQL 2012 cluster, when the clustered instance's...

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

    July 20, 2015 at 12:45 pm

    #1813721

Viewing 15 posts - 20,086 through 20,100 (of 59,098 total)