Forum Replies Created

Viewing 15 posts - 35,911 through 35,925 (of 59,102 total)

  • RE: How to Insert Million of records in less time ?

    wu.wuqiang (11/26/2010)

    Remove indexes before insertion, then recreate indexes.

    That frequently does nothing for the amount of time it takes because reindexing can take a lot of time. In fact, if...

    --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 26, 2010 at 9:33 am

    #1255843

  • RE: JOIN Question

    Grinja (11/26/2010)

    Hi Jef, that is correct.

    The account belongs to Bob for period 200801 - 200802 and to Fred from 200803 onwards.

    G

    In that case, it looks like TommyH has the code...

    --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 26, 2010 at 9:26 am

    #1255842

  • RE: Database Standards Parsing

    I guess now is as good a time to mention it as any...

    Code reviews (and unit testing... but that's a different subject) are super important to success. When 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 26, 2010 at 8:57 am

    #1255835

  • RE: Database Standards Parsing

    MysteryJimbo (11/26/2010)

    Apex have a tool called SQL Enforce which you can completely customise using a .net language.

    I've used it in the past but couldnt get the backing of the development...

    --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 26, 2010 at 8:27 am

    #1255829

  • RE: Copying data from multiple related tables

    Flodpanter (11/26/2010)

    This Insert will create 100 new records all with unique identity values in the table dbo.table_referencing_project. Now I have to copy all data that references the dbo.table_referencing_project table. These...

    --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 26, 2010 at 8:18 am

    #1255828

  • RE: Copying data from multiple related tables

    WO (11/26/2010)

    Jeff, Thank you for correcting me, while posting my reply I suddenly remembered having this problem with identity values a while back so I thought it be worth mentioning....

    --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 26, 2010 at 8:14 am

    #1255826

  • RE: Alternative To Cursors?

    patelmohamad (11/26/2010)

    HI,

    Avoid Cursor , Using While loop

    No insult intended but that's just not good advice. A good FAST FORWARD, READ ONLY, STATIC cursor is nothing more than a Temp...

    --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 26, 2010 at 8:10 am

    #1255825

  • RE: Do You Talk Salary in the Interview?

    simonk1971 (11/26/2010)

    Who would even go to interview without having an idea of the salary range available anyway?

    Just about anyone who's been out of work for a while. Also 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 26, 2010 at 8:02 am

    #1255822

  • RE: Database Standards Parsing

    Joe Fuller (11/25/2010)

    Good Idea.

    Besides those Jeff has mentioned>

    What do you look for?

    Table names (and most other SQL objects. that don't use only the 2 part naming convention. The 2...

    --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 25, 2010 at 10:13 pm

    #1255696

  • RE: Do You Talk Salary in the Interview?

    I agree... I usually don't even entertain the idea of an interview unless I already know the salary range. I don't want to waste their time or my time.

    There...

    --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 25, 2010 at 9:36 pm

    #1255695

  • RE: Are the posted questions getting worse?

    LutzM (11/25/2010)

    Jeff Moden (11/24/2010)

    It's a little out of character for me but I know you'll recognize the rhetoric. I just couldn't resist... it was too perfect. Enjoy... 😛

    http://www.sqlservercentral.com/Forums/Topic1025567-392-1.aspx#bm1026289

    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 25, 2010 at 9:33 pm

    #1255694

  • RE: vbscript query

    Lowell (11/25/2010)

    is that characters 10 thru 20 of the whole file, or 10 thru 20 for each row/line in the file? so if the file has 120 lines, you need...

    --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 25, 2010 at 9:16 pm

    #1255692

  • RE: Data Types

    Nakul Vachhrajani (11/25/2010)

    da.drew (11/25/2010)

    Hi thanks for your reply, that all makes good sense. What would you suggest for Dates, I read on a website that SQL Server has:

    datetime -...

    --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 25, 2010 at 9:12 pm

    #1255691

  • RE: Data Types

    Brigadur (11/25/2010)

    Hi,

    My recommendations:

    Postcode

    If you always have same length then use char(<length>). If it can have different lengths like international postcodes, safest is nvarchar(<length>).

    Telephone Number, Mobile Number

    These can indeed 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)

    November 25, 2010 at 9:09 pm

    #1255690

  • RE: Pass Parameter technique

    dtopicdragovic (11/25/2010)

    Thanks for all your input.

    I will post back once I decide the way I will do it.

    That would be a really cool thing to do because a lot of...

    --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 25, 2010 at 9:02 pm

    #1255689

Viewing 15 posts - 35,911 through 35,925 (of 59,102 total)