Forum Replies Created

Viewing 15 posts - 18,586 through 18,600 (of 59,098 total)

  • 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

  • RE: Joining Tables with Right Function

    ChrisM@Work (1/18/2016)

    Jeff Moden (1/18/2016)

    ChrisM@Work (1/18/2016)

    Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?

    With the battles I'm currently facing...

    --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 9:55 am

    #1852537

  • RE: Joining Tables with Right Function

    ChrisM@Work (1/18/2016)

    Jeff Moden (1/18/2016)[hrCan we agree on "SARGable in one direction only" as it's often sufficient to permit tweaking a decent plan?

    With the battles I'm currently facing at work 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)

    January 18, 2016 at 7:32 am

    #1852512

  • RE: Having fun with PARSENAME (SQL Spackle)

    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 IPs as big-endian bigint...

    --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 7:15 am

    #1852510

  • RE: Having fun with PARSENAME (SQL Spackle)

    thierry.vandurme (1/18/2016)

    I think these helper functions are now deprecated and you need to add a directive to the code to ignore the warnings about that.

    Thanks, Thierry.

    Heh... deprecation. It's...

    --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 7:10 am

    #1852509

Viewing 15 posts - 18,586 through 18,600 (of 59,098 total)