Forum Replies Created

Viewing 15 posts - 18,556 through 18,570 (of 59,072 total)

  • RE: Partition Table by Year

    I'll also add that the people that want to do the partitioning for performance are making a big mistake. Partitioning doesn't improve performance in almost every case. Proper...

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

    January 19, 2016 at 11:41 am

    #1852888

  • RE: Partition Table by Year

    Welsh Corgi (1/19/2016)

    There are only 1,296,391 records but the table is wide.

    I recommended that we did not partition the table. There is too much risk among other things but someone...

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

    January 19, 2016 at 11:38 am

    #1852881

  • RE: Partition Table by Year

    J Livingston SQL (1/19/2016)

    deja vu

    http://www.sqlservercentral.com/Forums/Topic1696588-3077-1.aspx

    Heh... I thought this looked familiar.

    My advice in my previous post stands, though. 🙂

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

    January 19, 2016 at 11:10 am

    #1852868

  • RE: Partition Table by Year

    Welsh Corgi (1/19/2016)

    The records in the call table are updated Regularly.

    Thanks.

    So, you're saying that rows for calls placed in 2014 can be updated in 2016? Something is VERY wrong...

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

    January 19, 2016 at 11:09 am

    #1852867

  • RE: Partition Table by Year

    Welsh Corgi (1/19/2016)

    Jeff Moden (1/19/2016)

    Welsh Corgi (1/19/2016)

    The ID Column is the Primary Key.

    I archive some records already.

    To what extent would that complicate things?

    Possibly, a shedload. What have you used...

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

    January 19, 2016 at 10:56 am

    #1852859

  • RE: Partition Table by Year

    Welsh Corgi (1/19/2016)

    The ID Column is the Primary Key.

    I archive some records already.

    To what extent would that complicate things?

    Possibly, a shedload. What have you used as 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)

    January 19, 2016 at 10:35 am

    #1852848

  • RE: The DBA Tax

    Wayne West (1/19/2016)

    Doctor Who 2 (7/9/2012)

    ... Bottom line: if the agency is small enough, they don't want a DBA. They're not willing to pay that "DBA tax". They'll...

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

    January 19, 2016 at 9:12 am

    #1852819

  • RE: Checking the bitwise value of an integer

    aaron.reese (1/18/2016)

    Jacob Wilkins (1/13/2016)

    I might be misunderstanding you, but if you're starting with the integer value (it sounds like you are?), then I find this method a bit more straightforward,...

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

    January 18, 2016 at 6:42 pm

    #1852631

  • RE: Checking the bitwise value of an integer

    Jacob Wilkins (1/13/2016)

    I might be misunderstanding you, but if you're starting with the integer value (it sounds like you are?), then I find this method a bit more straightforward, using...

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

    January 18, 2016 at 6:23 pm

    #1852630

  • RE: which one is better, Char and More Pages Or Varchar and High Fragmentation ?

    er.mayankshukla (1/18/2016)

    Hi all,

    In our dev environment, it is a common practice to use varchar columns instead of Char so that less space is required and accordingly index size will 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)

    January 18, 2016 at 2:18 pm

    #1852603

  • RE: Today's Random Word!

    Ed Wagner (1/18/2016)

    whereisSQL? (1/18/2016)

    Jeff Moden (1/18/2016)

    Revenant (1/18/2016)

    Ed Wagner (1/18/2016)

    djj (1/18/2016)

    Ed Wagner (1/18/2016)

    whereisSQL? (1/18/2016)

    djj (1/18/2016)

    Grumpy DBA (1/18/2016)

    Ed Wagner (1/16/2016)

    SQLRNNR (1/15/2016)

    Ed Wagner (1/15/2016)

    crookj (1/15/2016)

    SQLRNNR (1/15/2016)

    firecracker

    banger

    Mash

    pudding

    Bread

    Wonder

    Woman

    Justice (league)

    Lawyers

    Shyster

    Cheat

    Two-timer

    Four Flusher (Note... not a reference to...

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

    January 18, 2016 at 1:46 pm

    #1852592

  • RE: Today's Random Word!

    Revenant (1/18/2016)

    Ed Wagner (1/18/2016)

    djj (1/18/2016)

    Ed Wagner (1/18/2016)

    whereisSQL? (1/18/2016)

    djj (1/18/2016)

    Grumpy DBA (1/18/2016)

    Ed Wagner (1/16/2016)

    SQLRNNR (1/15/2016)

    Ed Wagner (1/15/2016)

    crookj (1/15/2016)

    SQLRNNR (1/15/2016)

    firecracker

    banger

    Mash

    pudding

    Bread

    Wonder

    Woman

    Justice (league)

    Lawyers

    Shyster

    Cheat

    Two-timer

    Four Flusher (Note... not a reference to my morning constitutional :-D)

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

    January 18, 2016 at 12:21 pm

    #1852572

  • RE: Turn Out the Lights

    Henry B. Stinson (1/18/2016)

    Also, if programmers were not allowed to write SQL code.

    It funny that you should bring that up, Henry. I'm working with a DBA at a small...

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

    January 18, 2016 at 12:13 pm

    #1852566

  • RE: Turn Out the Lights

    Ed Wagner (1/18/2016)

    I'll end my rant on that note.

    Heh... do you have to? I was rather enjoying it because it's exactly the way I think about these things.

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

    January 18, 2016 at 10:48 am

    #1852549

  • RE: Having fun with PARSENAME (SQL Spackle)

    Eirikur Eiriksson (1/18/2016)

    Jeff Moden (1/18/2016)

    Eirikur Eiriksson (1/18/2016)

    Network endian-ness is predominantly big-endian and the method NetworkToHostOrder will swap the byte order to small-endian. This tells me that you are storing 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)

    January 18, 2016 at 10:22 am

    #1852543

Viewing 15 posts - 18,556 through 18,570 (of 59,072 total)