Forum Replies Created

Viewing 15 posts - 16,486 through 16,500 (of 59,067 total)

  • RE: Are the posted questions getting worse?

    Luis Cazares (10/26/2016)

    Ed Wagner (10/26/2016)

    Phil Parkin (10/26/2016)

    Any clairvoyants here today?

    I admit that's very tempting, but I don't want to get drawn into a battle of sarcastic remarks that have nothing...

    --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 3:54 pm

    #1909024

  • RE: Can I do this?

    Sterling Ostin (10/26/2016)

    Sergiy,

    I did read Luis' post and incorporated it in an even more graceful and shorter solution that best suited my need.

    In the future, maybe you ought to question...

    --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 3:49 pm

    #1909023

  • RE: Compare two columns before insert

    ng_vg (10/26/2016)

    you can user MERGE statement.

    compare the column in both the tables , if doesnt exist then insert else update

    MERGE has had some huge problems in the past. I...

    --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 3:45 pm

    #1909022

  • 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

    Dunno. I've never been one to follow the proverbial...

    --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 3:42 pm

    #1909021

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

    jasona.work (10/26/2016)

    Siberian Khatru (10/26/2016)

    So if I understand things correctly, if I have these set to Simple mode, then the size of the trans log is really not all that important...

    --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 3:37 pm

    #1909020

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

    HanShi (10/26/2016)

    Jeff Moden (10/26/2016)

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

    --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 2:39 pm

    #1909005

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

    HanShi (10/26/2016)

    I understand the goal Jeff is after, but leaving the LOG grow for a whole week (in FULL recovery model) is IMO a large overkill with potential disaster on...

    --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 2:35 pm

    #1909004

  • RE: Windows Function

    drew.allen (10/26/2016)

    Jeff Moden (10/25/2016)

    As a bit of a sidebar, it would have been nice if they had it default to a ROWS specification because it's faster than the RANGE specification.

    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 9:36 am

    #1908929

  • RE: SQL Backup running long

    Imke Cronje (10/25/2016)

    Thanks! There is a difference with the backup times.

    Last nights speeds was slower. The average speed is 300MB\sec.

    I just went through that over the weekend and yesterday.

    First, 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 9:28 am

    #1908927

  • RE: SQL Backup running long

    ScottPletcher (10/25/2016)

    Have you considered differential backups for daily, with perhaps a full backup only weekly (at whatever your least active time during the week is)?

    Does your version of SQL allow...

    --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 9:09 am

    #1908923

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

    Phil Factor (10/26/2016)

    You can also export text files very easily from SQL Server using an ODBC text database. Hmm. Perhaps I should write an article about that, but I...

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

    #1908917

  • 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

Viewing 15 posts - 16,486 through 16,500 (of 59,067 total)