Forum Replies Created

Viewing 15 posts - 5,416 through 5,430 (of 59,089 total)

  • Reply To: Whether to leave a clustered index on a staging table

    It's a "staging" table, right?  Do you actually need a Clustered Index on it?  While it usually is a "Best Practice" to have a good Clustered Index on permanent tables,...

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

    April 11, 2021 at 11:37 pm

    #3867915

  • Reply To: Are the posted questions getting worse?

    Heh... a little Sunday morning laugh for everyone... It's simply titled "DevOps engineer during automation of CI-CD ".  I have a real-live appreciation for what they frequently have to go...

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

    April 11, 2021 at 2:19 pm

    #3867817

  • Reply To: Huge size of Reporting tables

    Just for your information, Thomas Grosher works with reporting databases that dwarf even the sizes reported on this thread.  He recently did a presentation for the "Cloud Driven Data" Meetup...

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

    April 11, 2021 at 1:40 pm

    #3867807

  • Reply To: Huge size of Reporting tables

    S_Kumar_S wrote:

    We have dedicated Sr. People for optimization and they have been doing it for more than a decade for some good clients. So we trust their understanding for 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)

    April 9, 2021 at 2:28 am

    #3867067

  • Reply To: sql backup for big database in 4 steps

    Johan Bijnens wrote:

    Jeff Moden wrote:

    ....  Compressed backups are only available in the Enterprise Edition for production environments (and Developer's Edition for development/testing environments)....

    Compressed backups are available on every edition except Express Edition ...

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

    April 8, 2021 at 2:54 pm

    #3866881

  • Reply To: Restoring Master on a Windows 2019 / SQL Server 2019 Cluster

    Awesome article, Johan!  Thanks a million!

     

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

    April 8, 2021 at 4:30 am

    #3866654

  • Reply To: sql backup for big database in 4 steps

    If you move tables to another database, remember that DRI (Declared Referential Integrity, like FKs, etc) won't work across databases.

    I totally agree with Page/Row Compression, compressed columns using the COMPRESS/DECOMPRESS...

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

    April 8, 2021 at 4:23 am

    #3866652

  • Reply To: Using REVERSE

    ScottPletcher wrote:

    Jeff Moden wrote:

    ScottPletcher wrote:

    You don't really need a pk or any other column from the main table.  Also, I assumed you're rather see blank than NULL for missing levels, 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)

    April 8, 2021 at 2:43 am

    #3866639

  • Reply To: COUNT(ID COLUMN) not using Clustered Index

    ScottPletcher wrote:

    Jeff Moden wrote:

    Although the PK is frequently also the clustered index, it's not necessarily so.  The keys of non-clustered indexes include the keys of the clustered index, which isn't necessarily...

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

    April 8, 2021 at 2:39 am

    #3866637

  • Reply To: sql backup for big database in 4 steps

    Just as a side bar, a search engine search for "backup database to multiple files sql server" yields a large number of articles on the subject.

    From that lot, the simplest...

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

    April 8, 2021 at 2:27 am

    #3866633

    • Viewing 15 posts - 5,416 through 5,430 (of 59,089 total)