Forum Replies Created

Viewing 15 posts - 39,136 through 39,150 (of 59,072 total)

  • RE: Why Be an MCP?

    Question Guy (3/30/2010)

    I'd have to say battlefield experience takes a huge it when a person does not have certifications. Whenver I've been interviewed, people were typically excited that I had...

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

    March 30, 2010 at 1:20 pm

    #1142618

  • RE: Why Be an MCP?

    AspiringGeek-40457 (3/30/2010)

    I can guarantee that training is *not* a profit center for Microsoft.

    Unless you work for Microsoft or have a Microsoft URL stating that, I'm pretty sure you can make...

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

    March 30, 2010 at 1:18 pm

    #1142615

  • RE: any tips on anonymising data

    aaron.reese (3/30/2010)

    Hi guys,

    I am being asked to restore a live database to a training environment. The database contains patient confidential records and I would like to keep all 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)

    March 30, 2010 at 1:15 pm

    #1142612

  • RE: Frequently fragmented indexes

    Marios Philippopoulos (3/30/2010)

    I have noticed that a number of nonclustered indexes in my database are getting frequently (almost daily) fragmented (fragmentation > 10%).

    Because of the size of the underlying...

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

    March 30, 2010 at 1:13 pm

    #1142608

  • RE: The Missing Certification

    WayneS (3/30/2010)

    Kit G (3/30/2010)

    I just realized I'm not understanding the context of a word being used here. That word is "gamer".

    From the search I did on the Internet 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)

    March 30, 2010 at 12:26 pm

    #1142560

  • RE: Today's Random Word!

    sing4you (3/30/2010)

    soft-shelled crab roll

    BWAA-HAA!!! "First Wife". 😀

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

    March 30, 2010 at 11:27 am

    #1142493

  • RE: The Missing Certification

    GSquared (3/30/2010)

    There is no way short of hiring someone and putting them to work, to fully verify that someone knows the skills they are claiming. None that's realistic, anyway.

    You've seen...

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

    March 30, 2010 at 11:18 am

    #1142486

  • RE: Why Be an MCP?

    blandry (3/30/2010)

    I am tired of this debate and can only address it as I know it...

    The best DBAs that I have seen, worked with, or had work for me, DID...

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

    March 30, 2010 at 6:54 am

    #1142149

  • RE: Datediff doubt

    gaurav-404321 (3/30/2010)

    I am using datediff functionm to calculate the days span between two dates

    SET @StartDate=cast('2010-01-26 00:00:00.000' as datetime)

    SET @EndDate=cast('2010-02-25 00:00:00.000' as datetime)

    SET @TotalDaysInSalaryPeriod= DATEDIFF(dd,@StartDate,@EndDate)

    this is giving 30 as output.

    But...

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

    March 30, 2010 at 6:50 am

    #1142145

  • RE: Datediff doubt

    Um... no, Dugi. Don't use the 23:59:59.999 thing.

    There are two reasons. First, anything larger than 23:59:59.997 will round up to the next day. Second, with some 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)

    March 30, 2010 at 6:47 am

    #1142141

  • RE: Ranking columns

    markjrouse (3/30/2010)

    Hi, here is a sample and expected result

    A B ...

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

    March 30, 2010 at 6:42 am

    #1142134

  • RE: Aggregation of records

    My recommendation is that you read the article at the first link in my signature line below.

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

    March 30, 2010 at 6:38 am

    #1142126

  • RE: Split column values into multiple rows using sql

    sqluserr (3/30/2010)

    Please let me know if you need any other details.

    I already did. Please see my previous post on this thread.

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

    March 30, 2010 at 6:30 am

    #1142119

  • RE: Best way to transpose multiple rows onto 1 row?

    Paul White NZ (3/30/2010)

    derrysql (3/30/2010)

    Thank you for this. What sort of structure would the 'Tally' table have?

    Details here: http://www.sqlservercentral.com/articles/67899/

    Notice: same author (Jeff Moden) as the Dynamic Pivot article 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)

    March 30, 2010 at 5:53 am

    #1142090

  • RE: The Missing Certification

    Gift Peddie (3/29/2010)

    All I want is please leave the doors open to all [font="Arial Black"]with the ability[/font].

    Exactly... 🙂

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

    March 29, 2010 at 7:39 pm

    #1141884

Viewing 15 posts - 39,136 through 39,150 (of 59,072 total)