Forum Replies Created

Viewing 15 posts - 20,791 through 20,805 (of 59,072 total)

  • RE: Space needed for clustered index rebuild

    GilaMonster (5/10/2015)

    Jeff Moden (5/10/2015)

    The only recommendation for space savings is to DISABLE NCIs prior to a rebuild.

    Which itself is wrong, because ALTER INDEX .. REBUILD on the clustered index...

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

    May 10, 2015 at 2:28 pm

    #1796855

  • RE: Space needed for clustered index rebuild

    P.S.

    Just to be sure, I did a deep dive double-check in Books Online and, as logical as it might seem, I can't find where it even implies that WITH DROP...

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

    May 10, 2015 at 1:55 pm

    #1796851

  • RE: Space needed for clustered index rebuild

    Eirikur Eiriksson (5/10/2015)

    Ken Davis (5/9/2015)

    I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB. ...

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

    May 10, 2015 at 1:17 pm

    #1796849

  • RE: Space needed for clustered index rebuild

    Ken Davis (5/9/2015)

    I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB. I would...

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

    May 10, 2015 at 10:04 am

    #1796844

  • RE: Temporary Stored Procedures

    Your Name Here (5/8/2015)

    @JeffM:

    I can give you an example but I'll put a disclaimer right up front: it's not a great example or even a great reason to do it,...

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

    May 10, 2015 at 8:25 am

    #1796843

  • RE: Temporary Stored Procedures

    radek.celuch (5/10/2015)

    Jeff Moden (6/27/2013)

    This does an "old fashioned unpivot" of the data (CBAC but still better than RBAR)

    Could you please explain the CBAC acronym used in this context? Thanks 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)

    May 10, 2015 at 8:06 am

    #1796842

  • RE: Today's Random Word!

    Revenant (5/9/2015)

    TomThomson (5/9/2015)

    Eirikur Eiriksson (5/9/2015)

    SQLRNNR (5/8/2015)

    eros

    Freyja

    Fólkvangr

    Field

    Ninth

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

    May 9, 2015 at 6:20 pm

    #1796828

  • RE: Execution Plan Question

    Alan.B (5/8/2015)

    There is no WHERE clause in a SELECT statement. There is a WHERE clause in a SQL Query. I'm not trying to be snarky here - it's just worth...

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

    May 9, 2015 at 5:42 pm

    #1796827

  • RE: Silent install SQL Server 2012 on Server 2012R2

    Steven DBA (5/9/2015)

    you have an additional backslash at the end of the on the INSTALLSQLDATADIR entry

    INSTALLSQLDATADIR="C:\Program Files\Microsoft SQL Server\"

    make this

    INSTALLSQLDATADIR="C:\Program Files\Microsoft SQL Server"

    Yowch! Good eye. It's things...

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

    May 9, 2015 at 5:24 pm

    #1796826

  • RE: The Service Pack Fiasco

    I think it's actually worse than you say. If you look at some of the horrendous problems on CONNECT that occurred with 2012 and the continuing lack of attention...

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

    May 9, 2015 at 5:21 pm

    #1796825

  • RE: Tips to Optimize Your SQL Statements - Part 2

    Understood and I also appreciate the fact that you brought up reworking queries in your article.

    I brought up the Recovery Model switch specifically because of the following post...

    brian118 (5/8/2015)

    george.p (5/8/2015)

    Why...

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

    May 9, 2015 at 4:42 pm

    #1796823

  • RE: Temporary Stored Procedures

    sanjarani (5/9/2015)

    One of many SQL Servers features that is hardly ever used because alternative methods are more suitable.

    Please explain your "alternative methods" and how they are "more suitable".

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

    May 9, 2015 at 4:10 pm

    #1796822

  • RE: Transaction on database

    eboucicaut (5/8/2015)

    Hello everyone,

    i would like to know it's possible to find all transaction(insert, delete,update) on a database for a day. if yes what can i do.

    thank you.

    Is this an interview...

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

    May 9, 2015 at 9:52 am

    #1796813

  • RE: MCSA 70-461 Question

    ScottPletcher (5/8/2015)

    Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??

    Heh.... exactly why I've...

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

    May 9, 2015 at 9:51 am

    #1796812

  • RE: Storing Values for Bitwise &

    Store it as VARBINARY and "byte slice" it like they do with "Columns_Updated" in triggers. See the article at the following link, especially example "B". It won't be...

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

    May 9, 2015 at 9:43 am

    #1796811

Viewing 15 posts - 20,791 through 20,805 (of 59,072 total)