Forum Replies Created

Viewing 15 posts - 23,596 through 23,610 (of 59,102 total)

  • RE: Getting the minimum and the maximum values in a large table

    Ahhhh.... be careful folks. This table is a 300 MILLION row table according to the op. Even with as narrow as it is, that could take up quite...

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

    May 23, 2014 at 5:15 pm

    #1716280

  • RE: Would rebuilding / reorganizing an index free up space in a DB?

    There are some other optimizations and considerations to be made, as well.

    Even if space and concurrent availabilty aren't issues for someone, there are a ton of optimizations and caveats to...

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

    May 23, 2014 at 5:05 pm

    #1716278

  • RE: Working with large database tables

    HildaJ (5/23/2014)

    We're planning to do all sorts of aggregation and select statements. The main tables that I'm talking about are recording financial transactions (payments and invoices mostly but also...

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

    May 23, 2014 at 12:08 pm

    #1716206

  • RE: Should We Move to Azure?

    I'd REALLY be interested in this especially if a comparison of costs between the current rendition of SSC and the cloud version were CAREFULLY TRACKED and revealed. I think...

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

    May 23, 2014 at 11:06 am

    #1716185

  • RE: TempTables

    TheSQLGuru (5/23/2014)

    Plenty of good tips here. I would like to add mine, at least, what I've seen from my Developers.

    If the temp table does not need Indexes, don't create 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)

    May 23, 2014 at 8:43 am

    #1716106

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/23/2014)

    Jeff Moden (5/23/2014)

    BWFC (5/23/2014)

    Ed Wagner (5/23/2014)

    Koen Verbeeck (5/23/2014)

    BWFC (5/23/2014)

    Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer...

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

    May 23, 2014 at 8:21 am

    #1716091

  • RE: Are the posted questions getting worse?

    BWFC (5/23/2014)

    Ed Wagner (5/23/2014)

    Koen Verbeeck (5/23/2014)

    BWFC (5/23/2014)

    Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? ...

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

    May 23, 2014 at 7:53 am

    #1716069

  • RE: TempTables

    spaghettidba (5/23/2014)

    Both INSERT INTO and SELECT ... INTO can achieve minimal logging.

    INSERT INTO can be minimally logged if the following conditions are met:

    * The recovery model of the database 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)

    May 23, 2014 at 7:15 am

    #1716043

  • RE: Master thesis on Business Intelligence

    amela.ajanovic90 (5/19/2014)

    Hey Jeff, sorry for the late reply. We are using the model from the paper "Time Flies When You're Having Fun: Cognitive Absorption and Beliefs About Information Technology Usage"...

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

    May 22, 2014 at 7:27 pm

    #1715925

  • RE: Linked AS400 stopped working

    John Cooper (5/22/2014)

    Thanks Jack !

    After much trial and error I found the trick.

    I set up a scheduled job that runs every 5 minutes that executes this statement:

    exec sp_enum_oledb_providers

    This is the...

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

    May 22, 2014 at 7:05 pm

    #1715923

  • RE: Table Naming Convention in SQL Server

    Learning1 (5/22/2014)

    Hello Experts,

    We are extracting data from multiple sources and staging the data in SQL Server tables. Once, the data is staged, we are doing some manipulations/calculations and create another...

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

    May 22, 2014 at 5:51 pm

    #1715916

  • RE: Cheats on the move

    GilaMonster (5/22/2014)

    Jeff Moden (5/22/2014)

    I always thought that testing facilities would at least check a driver's license for proof of identity.

    They're supposed to. Either fake IDs that are good enough 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)

    May 22, 2014 at 5:47 pm

    #1715915

  • RE: TempTables

    SQLRNNR (5/22/2014)

    ramana3327 (5/22/2014)

    Hi SQL RNNR,

    Your opinion is that there will nothing performance difference. Either way of creation of temp table is same.

    Performance between the two is equal.

    I guess I'd have...

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

    May 22, 2014 at 5:29 pm

    #1715911

  • RE: Cheats on the move

    Wow! Guess I was pretty naive. I didn't know such a company existed. I always thought that testing facilities would at least check a driver's license 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)

    May 22, 2014 at 8:10 am

    #1715707

  • RE: String question

    SQL_Novice23 (5/22/2014)

    I think I've got it to work. 🙂

    Thanks for your help on this one - a nice one to learn about.

    My SQL skill are improving slowly !!!

    Please post...

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

    May 22, 2014 at 8:06 am

    #1715705

Viewing 15 posts - 23,596 through 23,610 (of 59,102 total)