Forum Replies Created

Viewing 15 posts - 20,161 through 20,175 (of 59,072 total)

  • RE: A Case FOR Cursors...

    Hugo Kornelis (7/4/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?

    A few...

    --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 4, 2015 at 8:34 am

    #1810270

  • RE: Skill Supply and Demand

    andrew gothard (6/26/2015)

    Jeff Moden (6/25/2015)

    ... one of them even told me that he'd never worked with clustered indexes before because he'd never had to work with clustered servers before.

    Did you...

    --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 11:53 pm

    #1810264

  • RE: Project suggestion for a noob

    paul.knibbs (5/18/2015)

    Jeff Moden (5/16/2015)About 8 months ago I interviewed a handful of "developers" and a couple of "senior DBAs" that didn't know that ROW_NUMBER() even existed.

    Well, to be fair, if...

    --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 11:48 pm

    #1810263

  • RE: Problems importing CSV files using SSIS.

    Phil Parkin (6/2/2015)

    P Jones (6/2/2015)

    We do lots of csv import and have found that | isn't a good delimiter character as it can easily be mistyped into data when hitting...

    --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 11:19 pm

    #1810262

  • 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

Viewing 15 posts - 20,161 through 20,175 (of 59,072 total)