Forum Replies Created

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

  • 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

  • RE: function to clean a phonenumber

    Luis Cazares (10/25/2016)

    ninamahezi (10/25/2016)

    Hello,

    I want a sql function that will allow to make one update but with several replace on the same column.

    For exemple

    Replace the space by vacuum('')

    ...

    --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:10 pm

    #1908797

  • RE: Splitting Text Field into individual Columns

    Maybe if you're trying to do all this to a table, the cCA method might improve performance a bit because you can then take advantage of the starting position parameter...

    --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 10:41 pm

    #1908796

  • RE: Splitting Text Field into individual Columns

    pietlinden (10/25/2016)

    Jeff,

    My first thought was to be lazy and use DelimitedSplit8K but that would turn each occurrence into a separate record, right?

    Yes. You'd have to do a CROSS TAB...

    --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 10:03 pm

    #1908795

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