Forum Replies Created

Viewing 15 posts - 16,396 through 16,410 (of 59,101 total)

  • RE: How Do You Act When You Need to Learn New Technology?

    To be honest, I'm starting to get really pissed off at people and their "new improved shinny bobbles". I've spent countless hours listening patiently and doing due diligence 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 6, 2016 at 10:15 pm

    #1910815

  • RE: Are the posted questions getting worse?

    Luis Cazares (11/2/2016)

    I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

    That said, can anyone...

    --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 6, 2016 at 4:50 pm

    #1910810

  • RE: Are the posted questions getting worse?

    jasona.work (11/2/2016)

    Luis Cazares (11/2/2016)

    I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

    That said, can...

    --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 6, 2016 at 4:43 pm

    #1910809

  • RE: Execution Plan help. Estimates off by alot !

    thomashohner (11/6/2016)

    Thanks Jeff, i'll keep looking odd thing is I only have one <> 0 in the joins. Unfortunately I have not figured out away around it.

    edit: I lied 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)

    November 6, 2016 at 2:45 pm

    #1910808

  • RE: A Better sp_Spaceused

    Ed Wagner (11/6/2016)

    So they actually did work on it and yet the space "numbers" are still varchar(18). Sigh.

    The good part is that they didn't use FORMAT to format the numbers...

    --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 6, 2016 at 2:32 pm

    #1910807

  • RE: Flat File Source (CSV) rows discrepancy

    berryber (11/5/2016)

    Normally, googling and messing around, solves 99.999% of my IT (or relationship) problems. This one however, is giving me massive headaches.

    Situation:

    I have a package which runs over a selection...

    --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 6, 2016 at 1:57 pm

    #1910804

  • RE: Execution Plan help. Estimates off by alot !

    thomashohner (11/5/2016)

    Hello All,

    I need help on this execution plan. I recently made some changes to many of my tables. In my original setup which unfortunately i don't have any...

    --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 6, 2016 at 1:54 pm

    #1910803

  • RE: A Better sp_Spaceused

    Geez... it would have been SOOOOOOOO simple for them to make the "improvement" so much more worthwhile. I don't know why they even bothered.

    --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 6, 2016 at 1:06 pm

    #1910799

  • RE: Query to Dynamically Sum Sales Amounts By Month, Quarter, or Year

    I'm not sure who asked the question today but I got an email from the "webmaster", which means that someone hit "report" instead of "reply. Since I have no...

    --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 6, 2016 at 12:08 pm

    #1910798

  • RE: Maintain statistics on 1 TB Table

    Grant Fritchey (11/4/2016)

    I don't know if you're on 2008 or 2008R2, but if the latter, you should explore using traceflag 2371. It makes a huge difference for lots of people...

    --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 5, 2016 at 6:10 pm

    #1910782

  • RE: Maintain statistics on 1 TB Table

    Just to add a bit, you say that you're on 2008 R2. In that case, you can use sys.dm_db_stats_properties instead of sys.sysindexes to get the modified row count. ...

    --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 5, 2016 at 6:01 pm

    #1910781

  • RE: Maintain statistics on 1 TB Table

    curious_sqldba (11/4/2016)

    @jeff - Completely agree, stats are absolutely necessary. I use below code to check when were the stats last updated, i am not 100% satisfied on the results 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)

    November 5, 2016 at 5:15 pm

    #1910779

  • RE: What in the world is a partitioned table?

    scarr030 (11/5/2016)

    I'm familiar with partitioning a result set using the OVER(PARTITION BY.....) option. However, I'm reading a study kit by Itzik Ben-Gan, and he writes about partitioning views and references...

    --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 5, 2016 at 11:25 am

    #1910763

  • RE: Today's Random Word!

    Hugo Kornelis (11/4/2016)

    ZZartin (11/4/2016)

    whereisSQL? (11/4/2016)

    Ed Wagner (11/4/2016)

    Jeff Moden (11/4/2016)

    Eirikur Eiriksson (11/4/2016)

    crookj (11/4/2016)

    Luis Cazares (11/4/2016)

    djj (11/4/2016)

    Ed Wagner (11/4/2016)

    Revenant (11/4/2016)

    Hugo Kornelis (11/4/2016)

    Luis Cazares (11/4/2016)

    Match

    Winner

    Medal

    Olympics

    Olympian

    Zeus

    Orion

    The Hunter

    Betelgeuse

    Telescope

    Astronomy

    Phrenology

    Phrontistery[/url]

    Reverie

    --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 4, 2016 at 12:53 pm

    #1910711

  • RE: How to find executed time

    GilaMonster (11/4/2016)

    Jeff Moden (11/4/2016)

    With the understanding that it clears out on a restart of the SQL Service, you could also look at sys.dm_db_index_usage_stats. It won't differentiate between INSERTs and...

    --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 4, 2016 at 12:36 pm

    #1910704

Viewing 15 posts - 16,396 through 16,410 (of 59,101 total)