Forum Replies Created

Viewing 15 posts - 20,326 through 20,340 (of 59,098 total)

  • 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

  • RE: prevent sysadmin for access

    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 allow to see what...

    --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:26 am

    #1806112

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

    vliet (6/17/2015)

    As much as I do agree with all the arguments against using SELECT * I still think that your developer does not have to change this bad habit 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 9:15 am

    #1806103

  • RE: prevent sysadmin for access

    Sanz (6/17/2015)

    Why would you want to deny access to sysadmin ?

    Because a lot of companies make the huge mistake of allowing users and developers to have sysadmin privs. Only...

    --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:07 am

    #1806099

  • RE: Indexing Dates

    DonlSimpson (6/16/2015)

    pederson1234 (6/16/2015)

    Hey all, thanks for the feedback, i'm not quite there yet... Trying to simplify how I'm stating my need:

    This is what my table looks like:

    Customers

    Name, Date

    ‘John’, ‘2015-01-01’

    ‘John’,...

    --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 16, 2015 at 4:31 pm

    #1805923

Viewing 15 posts - 20,326 through 20,340 (of 59,098 total)