Forum Replies Created

Viewing 15 posts - 26,011 through 26,025 (of 59,099 total)

  • RE: List objects to move

    If they're moving the app to another server, I'd hope they'd be moving the data, as well. Why not skip all the work with scripts and just do a...

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

    September 2, 2013 at 7:35 pm

    #1646841

  • RE: sql 2012 dumps

    ramyours2003 (9/2/2013)

    Can any one send the sql 2012 dumps for getting the certified ?

    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)

    September 2, 2013 at 6:39 pm

    #1646836

  • RE: high cpu and parallelism

    Abu Dina (9/2/2013)

    You no longer MCM?!

    They're cancelling the MCM cert.

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

    September 2, 2013 at 6:25 pm

    #1646835

  • RE: IF Statement based on Multiple SELECT Statements

    wak_no1 (9/2/2013)

    Luis,

    Thank you for the reply.

    I have though worked it out! I used a JOIN in the IF statement, If the results of the Join were > 0, the script...

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

    September 2, 2013 at 6:22 pm

    #1646834

  • RE: Match Varbinary(max) with another Varbinary(max)

    chirag ~ (9/2/2013)

    i have a table with one binary column. that contains 0x00010100000101010101......00 column datalength is 35040, i am prepare this data like

    @Jobbyte = COALESCE(@Jobbyte , 0x) + Cast ((Case...

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

    September 2, 2013 at 6:16 pm

    #1646832

  • RE: sql query

    Erland Sommarskog (9/2/2013)

    I assume that you mean set-based iteration. That is by no means an atypical method, but one a good SQL programmer should master.

    Yes and absolutely agreed. That'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)

    September 2, 2013 at 6:05 pm

    #1646831

  • RE: Are the posted questions getting worse?

    I'll probably never go for the MCM or any other certification that MS has to offer (now that I've seen what MS does with the cream of the crop, I'm...

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

    September 2, 2013 at 5:41 pm

    #1646830

  • RE: sql query

    ramya.usapp (9/1/2013)

    Hello friends,

    Please help me in writing a query!!

    Question:

    Write a query based off of the following data stored in the AccountingEntry table. The query needs to return running totals...

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

    September 2, 2013 at 12:50 pm

    #1646795

  • RE: Help

    OTF (9/2/2013)

    I think people spend way more time than they should denegrating Certifications.

    I have to disagree in this area. I've had to work with a fairly large number 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)

    September 2, 2013 at 12:10 pm

    #1646789

  • RE: Get data month to calander week

    farrukhhameed786 (8/29/2013)

    I have attached a workbook to have a Idea how I need it.

    So... according to that partial spreadsheet (week 1 is missing a label as is the last week...

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

    August 31, 2013 at 1:07 pm

    #1646590

  • RE: I partitioning ever simple?

    taigovinda (8/30/2013)

    Thanks Jeff.

    From the looks of it I think there are a lot of other things I should learn before partitioning.

    Do you think that if I know 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)

    August 31, 2013 at 12:44 pm

    #1646586

  • RE: how to write query

    I don't need to run it from SQLCMD to see why. I've already demonstrated "Why" in the article. 😉

    So far as "Developer Productivity" goes, I'm all for that. ...

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

    August 31, 2013 at 12:38 pm

    #1646585

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/31/2013)

    GilaMonster (8/31/2013)

    Just ....

    Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.

    Sent late...

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

    August 31, 2013 at 10:37 am

    #1646580

  • RE: how to write query

    Erland Sommarskog (8/31/2013)

    Jeff Moden (8/30/2013)

    If you're interested in speed, STR isn't the way to do it.

    It's unlikely that the speed difference would be significant. Yes, if you need to do...

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

    August 31, 2013 at 10:15 am

    #1646575

  • RE: testing

    Test complete. Regard all further alarms. 🙂

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

    August 31, 2013 at 9:27 am

    #1646572

Viewing 15 posts - 26,011 through 26,025 (of 59,099 total)