Forum Replies Created

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

  • 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

  • RE: How to delete rows in multiple tables with foreign constraint rows at a time in singe query

    Just remember that ON DELETE CASCADE also allows mistaken manual deletes to spread the mistake to 4 other tables, as well. 😉

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

    #1715698

  • RE: Building a self-referencing hierarchical table.

    5 Levels is easy. Since you have 5 different tables, you'd need 5 queries and that will allow you to avoid dynamic SQL. The first query would be...

    --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 21, 2014 at 11:30 pm

    #1715563

  • RE: Recursive CTE? Not Sure How To Do This...

    autoexcrement (5/21/2014)

    @jeff, in testing your rCTE code on larger data sets, it seems to work most optimally in batches of about 1000 records at a time. (And even so, 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)

    May 21, 2014 at 11:26 pm

    #1715562

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