Forum Replies Created

Viewing 15 posts - 20,296 through 20,310 (of 59,072 total)

  • RE: A Syntax Mystery in a Previously Working Procedure

    I don't know why this article only got 3 stars. I'll admit that I didn't do a deep dive on the article (I'm familiar with the problem) but 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)

    June 18, 2015 at 7:57 am

    #1806378

  • RE: Are the posted questions getting worse?

    Sean Lange (6/17/2015)

    BL0B_EATER (6/17/2015)

    Brandie Tarvin (6/17/2015)

    O. M. G.

    You MUST read this link here.

    I'm in stitches here.

    Number 8 had me, having 2 under 2.5 years of age makes me feel like...

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

    June 18, 2015 at 7:37 am

    #1806367

  • RE: Question about xp_dirtree Procedure

    Understood on the xp_CmdShell thing. I was trying to give you fuel for your fire but there's a lot of overwhelming FUD out there and some companies just flat...

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

    June 18, 2015 at 7:25 am

    #1806363

  • RE: Bulk inserts in batch

    craig.g.smith (6/17/2015)

    The other reason I thought about just using the date is I'd really like to partition this table on that date.

    That was going to be my next recommendation. ...

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

    June 17, 2015 at 11:27 pm

    #1806260

  • RE: DBCC shrink file throwing server error

    Yeah... you're right, Joie. I'm not sure which command I was thinking about but it certainly isn't DBCC ShrinkFile that has this problem. Thank you for the catch.

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

    June 17, 2015 at 11:23 pm

    #1806259

  • RE: Need to track logins to all databases

    mark.dickinson (6/17/2015)

    B... Is there a way, based on the PostTime column, or a different column which could be added, to record only the most recent logon? For example, if FRED...

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

    June 17, 2015 at 10:47 pm

    #1806257

  • RE: Help! How to properly normalise a table from the start

    tomsharp85 (6/17/2015)

    Hi, I have a flat table with 17 columns of contact information with columns to seperate those contacts into different business classes. Here is the table:

    USE DataCompany

    CREATE TABLE ContactInformation

    (

    ID...

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

    June 17, 2015 at 10:41 pm

    #1806256

  • RE: Need code to list ID

    adonetok (6/17/2015)

    One column (memberID) store about 100 member ID like below

    000001

    000002

    ...

    000100

    How to code to output like below?

    000001, 000002,...000100

    Your turn, please. Why do you need the data in this format?...

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

    June 17, 2015 at 10:32 pm

    #1806254

  • RE: Question about xp_dirtree Procedure

    There is no guarantee that even something well documented will be in the next release, never mind undocumented features. Still, that doesn't stop me from using their power until...

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

    June 17, 2015 at 10:07 pm

    #1806253

  • RE: Bulk inserts in batch

    Consider using much larger batches, as well. I would recommend a batch size of 2 million rows and I strongly recommend that the batches be executed in the same...

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

    June 17, 2015 at 9:57 pm

    #1806252

  • RE: DBCC shrink file throwing server error

    Jo_DBA (6/16/2015)

    Hi,

    I am getting server error while trying to shrink the datafile

    history: we did some huge data purge on the db.

    original size of file : 1778050 MB

    free space:...

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

    June 17, 2015 at 9:27 pm

    #1806249

  • RE: Indexing Dates

    DonlSimpson (6/17/2015)

    Jeff Moden (6/16/2015)

    DonlSimpson (6/16/2015)

    A calendar or "dimDate" table will make this a much simpler task.

    How? He already supposedly has the dates he wants and just wants to number...

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

    June 17, 2015 at 3:12 pm

    #1806227

  • RE: Today's Random Word!

    eccentricDBA (6/17/2015)

    Ed Wagner (6/17/2015)

    Eirikur Eiriksson (6/17/2015)

    Ed Wagner (6/17/2015)

    Revenant (6/17/2015)

    Ed Wagner (6/17/2015)

    crookj (6/17/2015)

    DonlSimpson (6/17/2015)

    djj (6/17/2015)

    Ed Wagner (6/17/2015)

    djj (6/17/2015)

    Ed Wagner (6/17/2015)

    Eirikur Eiriksson (6/17/2015)

    Chocolate

    Dark

    Light

    Sabre

    Tooth

    Tiger (I don't think I had a choice)

    Woods

    Hunting

    Egg

    Omlet

    Allium sativum

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

    June 17, 2015 at 3:00 pm

    #1806225

  • RE: Need Ammunition for Developers Doing Select *'s

    patrickmcginnis59 10839 (6/17/2015)

    ZZartin (6/17/2015)Sometimes the only way people will accept they're wrong is if you prove them wrong. For example a perfectly plausible scenario is that columns are added...

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

    June 17, 2015 at 2:54 pm

    #1806221

  • RE: prevent sysadmin for access

    Lynn Pettis (6/17/2015)

    Jeff Moden (6/17/2015)

    Still, I continue to think it odd that possibly unqualified users can make changes through a GUI that might not have audit capabilities but DBAs aren't...

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

    June 17, 2015 at 2:49 pm

    #1806220

Viewing 15 posts - 20,296 through 20,310 (of 59,072 total)