Forum Replies Created

Viewing 15 posts - 16,366 through 16,380 (of 59,067 total)

  • 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

  • RE: What's Your Backup Speed?

    Nightly restore of 2 main production databases:

    DB1: 515GB, 13.35% free space, 10.0GB Log file

    DB2: 76GB, 36.69% free space, 33.5GB Log file (yeah... I know)

    Total time to restore including...

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

    #1910691

  • RE: Today's Random Word!

    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

    --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 11:57 am

    #1910685

  • RE: Recuperantion des données pour certains dimensions

    Luis Cazares (11/4/2016)

    Jeff Moden (11/3/2016)

    Luis Cazares (11/3/2016)

    I believe that you understood correctly, except for the part that the OP needs to get the MDX query instead of T-SQL.

    I know it'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)

    November 4, 2016 at 11:54 am

    #1910683

  • RE: How to find executed time

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

    November 4, 2016 at 8:50 am

    #1910616

Viewing 15 posts - 16,366 through 16,380 (of 59,067 total)