Forum Replies Created

Viewing 15 posts - 16,561 through 16,575 (of 59,101 total)

  • RE: Potential presentation idea: The magic of checklists

    Hi, Ray...

    I'm not sure that you're interested but, for me, check lists are uber important when writing code. I'll take a requirements document, draw a process chart of 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 24, 2016 at 2:48 pm

    #1908477

  • RE: Archiving Filegroups

    If you set such file groups to "Read Only", they not only won't need index maintenance but they also won't need to be backed up on every full backup.

    --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 24, 2016 at 2:41 pm

    #1908475

  • RE: Best Date Dimension Table

    krypto69 (10/24/2016)

    Having trouble finding the best date dimension table for financial data.

    Any recommendations?

    (I thought there was one posted here recently - but I can't find it)

    Yes. Tell us 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 24, 2016 at 12:18 pm

    #1908442

  • RE: database features

    BrainDonor (10/24/2016)

    sqlserverDBA2016 (10/24/2016)

    is it always better to add database features like analysis services and integration tools and reporting services

    when installing sql server instance, and it wont complicate and cause issues...

    --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 24, 2016 at 8:31 am

    #1908383

  • RE: Let the shell free

    Luis Cazares (10/24/2016)

    Jeff Moden (10/23/2016)

    The correct answer is only a 1/4 correct. You also have to enable advanced options and RECONFIGURE twice (once for the advanced options and once...

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

    #1908374

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

    Super_Grover (10/23/2016)

    I knew it is bad practice ...

    As with everything else in SQL Server, "It Depends".

    --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 23, 2016 at 11:37 pm

    #1908268

  • RE: Help understanding NC indexes and separate FileGroup

    thomashohner (10/23/2016)

    Thanks Jeff,

    After I posted I thought about it more and I guess the SAN made it kind of a moot point. Grant basically states at the beginning 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 23, 2016 at 11:34 pm

    #1908267

  • RE: Are the posted questions getting worse?

    Man, the spam is getting worse. The other morning, 41 out of 50 posts were spam. This morning is almost as bad. Most of it is URL-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)

    October 23, 2016 at 11:09 pm

    #1908266

  • RE: Clownpocalypse and DR

    The difference between Zombies and Clowns is simple. Zombies are external sources. Clowns are internal. 😉

    --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 23, 2016 at 11:06 pm

    #1908265

  • RE: Let the shell free

    The correct answer is only a 1/4 correct. You also have to enable advanced options and RECONFIGURE twice (once for the advanced options and once to enable xp_CmdShell.

    Heh... 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 23, 2016 at 11:01 pm

    #1908264

  • RE: Conflict in Functional Teams

    David.Poole (10/23/2016)

    The "team" is a fractal. Yes it means those in charge of the product but it also means that product is part of a wider team.

    In terms 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 23, 2016 at 1:43 pm

    #1908255

  • RE: Help understanding NC indexes and separate FileGroup

    thomashohner (10/23/2016)

    My ultimate question is would moving the indexes to another file group be beneficial ?

    My personal feeling is that it would do little to nothing, especially since you can'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)

    October 23, 2016 at 1:17 pm

    #1908253

  • RE: Conflict in Functional Teams

    Eirikur Eiriksson (10/23/2016)

    xsevensinzx (10/23/2016)

    David.Poole (10/22/2016)

    5. Not putting the team first.

    Actually, I slightly disagree with this. I feel conflict happens a lot because people are putting the team first over 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 23, 2016 at 12:33 pm

    #1908252

  • RE: Stop query if it is taking too long

    Eirikur Eiriksson (10/23/2016)

    Jeff Moden (10/23/2016)

    As a bit of a sidebar, I'm concerned for you good folks. One of the indexes you posted appears to have "CardNumber" as a clear...

    --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 23, 2016 at 12:25 pm

    #1908251

  • RE: Conflict in Functional Teams

    xsevensinzx (10/23/2016)

    David.Poole (10/22/2016)

    5. Not putting the team first.

    Actually, I slightly disagree with this. I feel conflict happens a lot because people are putting the team first over the business. We...

    --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 23, 2016 at 12:13 pm

    #1908248

Viewing 15 posts - 16,561 through 16,575 (of 59,101 total)