Forum Replies Created

Viewing 15 posts - 32,251 through 32,265 (of 59,099 total)

  • RE: Exceptional DBA 2011 Winner

    bitbucket-25253 (10/17/2011)

    Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt

    Thanks for all you have done to teach myself...

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

    October 17, 2011 at 10:04 pm

    #1395674

  • RE: Exceptional DBA 2011 Winner

    Ninja's_RGR'us (10/17/2011)

    Jeff Moden (10/17/2011)

    I certainly missed this one. Thanks folks! I really appreciate the great thoughts. :blush:

    Let's put it in the duplicate category ;-).

    Let's not. 😉

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

    October 17, 2011 at 10:02 pm

    #1395673

  • RE: Jeff Moden elected Exceptional DBA of 2011

    The award ceremony in Seattle has come and gone. It was absolutely awesome especially since I got to put a check-mark next to some folks' names on my "bucket...

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

    October 17, 2011 at 6:32 pm

    #1395659

  • RE: Exceptional DBA 2011 Winner

    I certainly missed this one. Thanks folks! I really appreciate the great thoughts. :blush:

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

    October 17, 2011 at 6:27 pm

    #1395657

  • RE: Typical DBA day...

    Dev @ +91 973 913 6683 (10/17/2011)

    since assignment of tasks frequently requires that "How" questions are frequently asked by the assignees.

    If you are getting too many 'How' questions,...

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

    October 17, 2011 at 4:23 am

    #1395218

  • RE: Reverse Treeview

    Alan Stanley (10/17/2011)

    The first CTE is being populated bottom up. i.e. we are passing in a list of branch nodes and getting back each node to the root.

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

    October 17, 2011 at 4:19 am

    #1395215

  • RE: Excel import - force column to be string (SSIS 2005)

    The way I solved this problem for my group was to simply use QUOTENAME(columnname, '"') and make sure that I used '"' as the text qualifier.

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

    October 16, 2011 at 6:03 pm

    #1395121

  • RE: Properly shutting down a SQL2005 db

    noyb 30173 (10/16/2011)

    The logfile 'was' over 220gb in size. Thankfully, I've managed to shrink it back to 20gb and recovery now occurs in about 60 seconds...quite an improvement!

    Next I will...

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

    October 16, 2011 at 5:50 pm

    #1395118

  • RE: switch tables based pm prefixes

    battery_acid_h (10/14/2011)

    This one is actually what I want to avoid, repeating the same script for each of the 50 odd companies. By that I mean, the union all script, which...

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

    October 16, 2011 at 5:28 pm

    #1395115

  • RE: what is poly performance on a sql statement

    2 way street here, AAKR. Please answer Gail's questions so we can all learn something new. Thanks.

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

    October 16, 2011 at 5:05 pm

    #1395110

  • RE: low tech pivot

    Nah... not to worry. Sometimes it's hard to put questions/requirements together. Now we know what a BA goes through. 😀 Glad I could help.

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

    October 16, 2011 at 5:01 pm

    #1395109

  • RE: low tech pivot

    In that case, how's this look?

    WITH

    cteUnPvt AS

    ( --=== Unpivot the data so we can work with it

    SELECT t.affil,

    t.Charqtr, ...

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

    October 16, 2011 at 4:58 pm

    #1395107

  • RE: low tech pivot

    Ok... with the understanding that I may not actually understand what you need, the following will do what I think you're saying using the test data you posted...

    WITH

    cteUnPvt AS

    ( --===...

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

    October 16, 2011 at 4:44 pm

    #1395104

  • RE: low tech pivot

    Drew,

    I'm really confused as to what you want to do. Your textual description says you want to "unpivot" the rows but your example is matching up quarter information based...

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

    October 16, 2011 at 4:03 pm

    #1395101

  • RE: Are the posted questions getting worse?

    GilaMonster (10/15/2011)

    Jeff Moden (10/15/2011)

    Heh... nah... you're a good friend... so I thawed the chops for ya. 😛

    And even de-boned and par-cooked em to be really nice.

    That was just for 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)

    October 16, 2011 at 1:23 pm

    #1395088

Viewing 15 posts - 32,251 through 32,265 (of 59,099 total)