Forum Replies Created

Viewing 15 posts - 24,406 through 24,420 (of 59,099 total)

  • RE: Oddball Interview Questions

    mwyss (2/12/2014)

    Jeff Moden (2/11/2014)

    As I've been known to say, "Before you can think outside the box, you must first realize... you're in a box". 🙂

    That's the trick right there -...

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

    February 12, 2014 at 8:14 am

    #1688378

  • RE: Archiving Data

    free_mascot (2/12/2014)

    Jeff, love to read the questioner you have asked? This reflect the experience you are carrying. Simply superb!!!

    Cheers,

    FM

    Thanks for the feedback, FM. I'm actually smack dab in 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)

    February 12, 2014 at 8:08 am

    #1688368

  • RE: Archiving Data

    durai nagarajan (2/11/2014)

    Thanks guys for your input

    They have decided to keep 3 months data so we are planning to move the current 3 months data to new table and 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)

    February 12, 2014 at 7:59 am

    #1688359

  • RE: high cpu

    pmadhavapeddi22 (2/12/2014)

    jeff,

    I have re written the query by joining the de norm table in from clause, but the no of

    reads and cpu are high with the new query. Old query...

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

    February 12, 2014 at 7:46 am

    #1688352

  • RE: Understanding the question at hand (word problems!)

    I can't speak for anyone else but I don't tolerate poorly written word problems in real life. If I have to guess as to their meaning, then I could...

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

    February 11, 2014 at 11:04 pm

    #1688214

  • RE: Oddball Interview Questions

    L' Eomot Inversé (2/11/2014)

    Miles Neale (2/11/2014)

    A wield question can cause a candidate to think and speak out of the box.

    If it takes a weird question to get the candidate...

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

    February 11, 2014 at 10:40 pm

    #1688212

  • RE: high cpu

    pmadhavapeddi22 (2/11/2014)

    Jeff,

    Sorry for the late reply,

    continuation of the above topic...

    As you asked, the below is one of the update statements we are using in stored procedure

    Update de_norm_buscard_attr ...

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

    February 11, 2014 at 4:16 pm

    #1688154

  • RE: create a table with two primary keys.

    sqlvogel (2/11/2014)

    Jeff Moden (1/30/2014)

    By definition and by design and as the others have stated, you cannot have two Primary Keys on a table. If you try to create a...

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

    February 11, 2014 at 4:03 pm

    #1688147

  • RE: wire server event log ss db?

    I pretty much suck at PowerShell simply because I don't use it for much. BUT, this looks like a great use for PowerShell and, combined with some interesting stuff...

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

    February 10, 2014 at 8:37 pm

    #1687765

  • RE: Selecting rows in a table.. not so simple!

    dwain.c (2/10/2014)

    Jeff Moden (2/10/2014)

    Regardless of the number of rows in the table, this can be done incredibly quickly IF you're only looking for one set that adds up to 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)

    February 10, 2014 at 8:10 pm

    #1687763

  • RE: Selecting rows in a table.. not so simple!

    Regardless of the number of rows in the table, this can be done incredibly quickly IF you're only looking for one set that adds up to the desired number.

    So... are...

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

    February 10, 2014 at 8:04 pm

    #1687760

  • RE: What if I have to shrink the database...:(

    SQLRNNR (2/10/2014)

    Jeff Moden (2/10/2014)

    SQLRNNR (2/10/2014)

    jewel.sacred (2/10/2014)

    @Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem...

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

    February 10, 2014 at 7:46 pm

    #1687757

  • RE: Performance Tuning Through Panic

    Gary Varga (2/10/2014)

    Another key issue is "perceived performance". I have worked on a number of systems when the performance has been drastically improved over the original system, however, the users...

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

    February 10, 2014 at 7:16 pm

    #1687749

  • RE: What if I have to shrink the database...:(

    SQLRNNR (2/10/2014)

    jewel.sacred (2/10/2014)

    @Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No disrespect 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)

    February 10, 2014 at 7:11 pm

    #1687748

  • RE: What if I have to shrink the database...:(

    SQLRNNR (2/10/2014)

    Jeff Moden (2/10/2014)

    Take a backup before doing the shrink and a backup prior to doing what comes up next...

    If you don't mind NOT having point-in-time backups while the 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)

    February 10, 2014 at 7:06 pm

    #1687746

Viewing 15 posts - 24,406 through 24,420 (of 59,099 total)