Forum Replies Created

Viewing 15 posts - 16,516 through 16,530 (of 59,101 total)

  • RE: Wasting Time

    Chris Harshman (10/27/2016)

    Miles Neale (10/12/2012)

    Meetings can be good. However, they need to be short, to the point, make decisions, and not be rambling sessions where everyone gets their say...

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

    #1909129

  • RE: Bit of a rant - queries on space

    Kazmerelda (10/25/2016)

    My email to them has said I am not prepared to take off backups, and my worry is we won't have that space put in for them.

    Ok... no pun...

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

    #1909035

  • RE: Simple Talk Website Redesign

    andrew.ing (9/7/2016)

    I wonder when sql server central will succumb to the red-and-black treatment.

    They kinda almost did a couple of times. The last time was when they started to make...

    --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 4:11 pm

    #1909027

  • RE: SQL Job - almost good

    Ed Wagner (10/26/2016)

    If I were doing this, I would fire the email and update the table in the same procedure. I don't see a reason to separate them, unless...

    --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 4:04 pm

    #1909026

  • 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

Viewing 15 posts - 16,516 through 16,530 (of 59,101 total)