Forum Replies Created

Viewing 15 posts - 20,191 through 20,205 (of 59,098 total)

  • RE: A Case FOR Cursors...

    andrew.norris 90251 (7/3/2015)

    Simple example. You have a parent child relationship in your data that has a ragged child hierarchy. You need to use different logic on different types of parent...

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

    July 3, 2015 at 10:24 pm

    #1810261

  • RE: Parsing large varbinary fields

    Tom, are you all set on this?

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

    July 3, 2015 at 8:27 pm

    #1810260

  • RE: OPENROWSET problem

    sgmunson (6/15/2015)

    I'll look forward to it, as this; for me anyway; definitely falls into the category of "I didn't know you could do that with just T-SQL". I...

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

    July 3, 2015 at 8:25 pm

    #1810259

  • RE: Need Ammunition for Developers Doing Select *'s

    Nah... you're not jaded... experienced and wise is more like it. I've see the same ridiculous things, even recently, like having the front end create and transmit a quarter...

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

    July 3, 2015 at 8:16 pm

    #1810258

  • RE: Just wondering how do you manage TEMPDB?

    To add to what Kris stated, we have several databases that are a bit over a 3rd of a Tera-Byte on a single instance. That instance has 8 -...

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

    July 3, 2015 at 7:23 pm

    #1810257

  • RE: A Case FOR Cursors...

    patrickmcginnis59 10839 (7/3/2015)

    Jeff Moden (7/3/2015)

    andrew.norris 90251 (6/7/2015)

    Nothing wrong with cursors they have their place and are very useful.

    Do you have examples for something other hierarchies and bin stacking problems?

    doing inserts...

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

    July 3, 2015 at 6:35 pm

    #1810255

  • RE: Archieving Data

    vivek.ghag52 (5/24/2015)

    I have an alternative to it.Please let me know if that will work.I will add another data file and move that specific table into that data file and then...

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

    July 3, 2015 at 2:05 pm

    #1810247

  • RE: A Case FOR Cursors...

    andrew.norris 90251 (6/7/2015)

    Nothing wrong with cursors they have their place and are very useful.

    Do you have examples for something other hierarchies and bin stacking problems?

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

    July 3, 2015 at 1:51 pm

    #1810246

  • RE: Exit Lines

    TomThomson (7/2/2015)

    The really sensible comments here are those from Gail and Jeff (that's pretty much as usual).

    I've usually limited myself to things like emailing my personal email address...

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

    July 2, 2015 at 8:23 pm

    #1810111

  • RE: ORDER BY = Bubble Sort ? Quick Sort ? Insertion Sort ?

    Pawan Kumar Khowal (7/1/2015)

    There are two different sort logics used by SQL Server to handle sorting! First one is the quick sort and another one is Merge sort. It begins...

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

    July 2, 2015 at 9:07 am

    #1809937

  • RE: The Importance of Our Work

    podmate (7/2/2015)

    My first career was literally saving babies (running life support on extremely premature infants).

    I find that IT is a far more stressful career than medicine.

    In medicine, we are (mostly)...

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

    July 2, 2015 at 7:53 am

    #1809888

  • RE: Are the posted questions getting worse?

    Luis Cazares (7/2/2015)

    jasona.work (7/2/2015)

    Today is the kind of day (and it's only been an hour and a half since I got to work) that you clock watch...

    OTOH, got plenty 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)

    July 2, 2015 at 7:46 am

    #1809885

  • RE: Are the posted questions getting worse?

    jasona.work (7/1/2015)

    QUICK! Look over there!! It's a dinosaur!!

    Dude... I'm standing right here...

    Sorry you missed seeing the dinosaur though, it was really cool...

    :hehe:

    Yes, we 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)

    July 1, 2015 at 4:14 pm

    #1809699

  • RE: The New DBA

    Ed Wagner (6/30/2015)

    Alvin Ramard (6/30/2015)

    Jeff Moden (6/30/2015)

    Steve Jones - SSC Editor (6/30/2015)

    GoofyGuy (6/30/2015)

    None of the following are technical questions, they're just simple and conversational, but they reveal a lot.

    One question...

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

    July 1, 2015 at 12:21 am

    #1809370

  • RE: Possible to find the parameters passed to an SP for performance tuning?

    jasona.work (6/30/2015)

    Ran into an issue with a stored procedure earlier today. The SP was taking a *long* time to return results which was causing it to block some other...

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

    June 30, 2015 at 3:55 pm

    #1809331

Viewing 15 posts - 20,191 through 20,205 (of 59,098 total)