Forum Replies Created

Viewing 15 posts - 20,056 through 20,070 (of 59,072 total)

  • RE: GREATEST and LEAST function

    SQLArnold (7/24/2015)

    Hello All,

    How would you do this with any and all dates?

    I am trying to think of a way to create a Greatest Value that will handle dates, different date...

    --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 25, 2015 at 1:08 am

    #1814942

  • RE: Is It Worth Writing Unit Tests?

    David.Poole (7/24/2015)

    Jeff Moden (7/23/2015)

    Hmmmm.... maybe I'm mistaking what some folks refer to as "unit tests".

    OK bad phraseology. Before TDD type practices.

    I can remember an impassioned debate about the adoption...

    --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 24, 2015 at 6:11 pm

    #1814937

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/24/2015)

    So everyone at work is thrilled with me right now for solving a slow-running report issue when I discovered 4 table scans (of the same table) in a...

    --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 24, 2015 at 11:38 am

    #1814860

  • RE: The Evolving DBA

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

    I find that it seems plenty of companies think a developer or sysadmin can do the job.

    No change there. Look at the posts on...

    --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:51 pm

    #1814620

  • 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

Viewing 15 posts - 20,056 through 20,070 (of 59,072 total)