Forum Replies Created

Viewing 15 posts - 16,531 through 16,545 (of 59,101 total)

  • RE: Windows Function

    scarr030 (10/26/2016)

    So, I guess the answer to my question, then, is 'because that's how they made it'. Fair enough! haha

    Heh... unfortunately, that's the answer to a great many mysteries in...

    --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 26, 2016 at 8:27 am

    #1908915

  • RE: Shrinking the Log file...best practices?

    p.s. As for ascertaining the recommended size for the log files, you could write a script to (for each DB)...

    1. Set the SIMPLE recovery model.

    2. Change 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 26, 2016 at 8:16 am

    #1908910

  • RE: Shrinking the Log file...best practices?

    Siberian Khatru (10/26/2016)I'm kind of torn here as to whether or not to bother other than to switch to SIMPLE. I would guess at this point that leaving the log...

    --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 26, 2016 at 8:05 am

    #1908899

  • RE: Shrinking the Log file...best practices?

    Siberian Khatru (10/26/2016)

    So here's my question then; Can I run a DBCC SHRINKFILE (or equivalent Management Studio Command) on these log files without causing index fragmentation? I think not, 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)

    October 26, 2016 at 7:11 am

    #1908874

  • RE: Shrinking the Log file...best practices?

    jasona.work (10/26/2016)

    First, shrinking the logs will fragment indexes, so you'll need to plan for some index operations afterwards.

    Careful, now. Shrinking the logs has no effect on fragmentation of indexes....

    --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 26, 2016 at 6:59 am

    #1908867

  • RE: 8 Ways to Export SQL Results To a Text File

    Excellent article! Really enjoyed it. Thanks for taking the time to write that bad boy.

    My only gripe would be this...

    From the article:

    Use it when you have millions 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)

    October 26, 2016 at 12:21 am

    #1908814

  • RE: sql backup

    Brandie Tarvin (10/25/2016)

    EdVassie (10/25/2016)

    One thing I did not see explicitly mentioned is the number of backup files.

    I don't know if this is true of all dedup technology, but the stuff...

    --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 26, 2016 at 12:02 am

    #1908809

  • RE: sql backup

    EdVassie (10/25/2016)

    One thing I did not see explicitly mentioned is the number of backup files. This can also reduce run time because SQL Server backs up a portion of 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 26, 2016 at 12:01 am

    #1908807

  • RE: Delete massive records and still can't shrink db

    Houston, the OP has left the building! 😀

    --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 25, 2016 at 11:54 pm

    #1908806

  • RE: Big data: transfer x-number of rows per batch?

    Phil Parkin (10/25/2016)

    wtren (10/25/2016)

    You should use bcp

    Please justify this comment.

    Although it was a bit short, it's not a bad idea. I've done similar before. Instead of messing around...

    --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 25, 2016 at 11:51 pm

    #1908805

  • RE: Clownpocalypse and DR

    Eric M Russell (10/25/2016)

    Marcia J (10/25/2016)

    I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So 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)

    October 25, 2016 at 11:45 pm

    #1908804

  • RE: Clownpocalypse and DR

    Gary Varga (10/25/2016)

    Geoff.Sturdy (10/25/2016)

    Gary - the two digit year was born out if the need to conserve memory in early systems - back in the late 70s /early 80s...

    --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 25, 2016 at 11:41 pm

    #1908803

  • RE: database features

    sqlserverDBA2016 (10/25/2016)

    in general , do most of dbas always install ssas and ssis and ssrs when installing sql server 2014

    I can't speak for others but I install everything, 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)

    October 25, 2016 at 11:29 pm

    #1908802

  • RE: function to clean a phonenumber

    ninamahezi (10/25/2016)

    thanks,

    I have never writen sql function. So I do not know what is.

    What we want to do is make an update on the phonenumber taking into account all these...

    --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 25, 2016 at 11:15 pm

    #1908801

  • RE: RabbitMQ via SQL Server

    TryingToLearn (10/25/2016)

    i need to create a queue via a trigger(i'm assuming) that will be consumed by a service/event bus in RabbitMQ. Would MSMQ be the proper way to proceed?

    We already...

    --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 25, 2016 at 11:14 pm

    #1908800

Viewing 15 posts - 16,531 through 16,545 (of 59,101 total)