Forum Replies Created

Viewing 15 posts - 26,131 through 26,145 (of 59,102 total)

  • RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

    LordHz (3/14/2013)

    Jeff,

    Not putting that back in the original table (mines not employee), I'm just maintaining the mapping in your hierarchy table. My thought is to make your stored procedure more...

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

    August 24, 2013 at 11:57 am

    #1644658

  • RE: Generating Dummy Data

    Hi Jamie,

    Despite the low number of stars on this article, I think the concept of this article is actually very good but the methods used in the code bit 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)

    August 24, 2013 at 11:05 am

    #1644656

  • RE: Always Abstract

    Craig-315134 (8/23/2013)

    @jeff Moden wrote:

    This is a part of what I'm talking about. Too many people think that the only way in or out of a database is through the UI...

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

    August 23, 2013 at 4:09 pm

    #1644601

  • RE: Get data for the past one year (365 days)

    sharonsql2013 (8/23/2013)

    Yes , Prod year is int.

    What about ProdMonth? We'll need that info to identify rows that are a year old. And, because you only have Year and...

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

    August 23, 2013 at 3:49 pm

    #1644595

  • RE: A question on defragging the *physical* files (mdf / ldf)

    sql-lover (8/23/2013)

    I am sorry to disagree... but for a SAN with actual mdf and ldf files there, I see no reason to defrag, specially if we are talking about TBs...

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

    August 23, 2013 at 3:44 pm

    #1644591

  • RE: Always Abstract

    Craig-315134 (8/23/2013)

    Seriously, though, Jeff, I don't think 'data safety and performance' and application layer abstraction must be mutually exclusive goals;

    I never said they needed to have mutually exclusive goals. ...

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

    August 23, 2013 at 3:34 pm

    #1644586

  • RE: Always Abstract

    Craig-315134 (8/23/2013)

    @jeff Moden wrote:

    Too many people get to most databases without using the application.

    ???

    Please explain, Jeff. You've thrown me. If people aren't using an application UI, what are they...

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

    August 23, 2013 at 3:18 pm

    #1644577

  • RE: Are the posted questions getting worse?

    Sean Lange (8/22/2013)

    Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀

    There's just...

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

    August 23, 2013 at 11:36 am

    #1644514

  • RE: Get data for the past one year (365 days)

    batgirl (8/23/2013)

    sharonsql2013 (8/23/2013)

    I am trying to view data for past one year ...Don't know whats wrong with the following:

    select ProdMonth ,ProdYear from Production

    where DATEADD(yyyy,-1,getdate())

    Kindly advise

    You will need to compare some...

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

    August 23, 2013 at 11:26 am

    #1644508

  • RE: Always Abstract

    Craig-315134 (8/23/2013)

    @jeff Moden wrote:

    Perhaps I think differently than most but, to me, there's almost no such thing as separate presentation, business, and data layers. For me, it's all about safety...

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

    August 23, 2013 at 11:17 am

    #1644504

  • RE: Zip code --> Distance in google maps

    countryflora13 (8/23/2013)

    So, where do we have to put this script I mean can I put it in my website or what? please explain little more

    Considering the generic nature of 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)

    August 23, 2013 at 11:10 am

    #1644499

  • RE: how to pass parameters into an openquery ?.

    wolfkillj (8/23/2013)

    Jeff Moden (8/21/2013)

    weston_086 (8/21/2013)

    Bcz i want to put the result of the stored proc into "dbo.INFORMATION" table.but it is giving me an error "unable to begin a distributed...

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

    August 23, 2013 at 11:03 am

    #1644495

  • RE: What to do about a complete lack of jobs?

    hisakimatama (8/23/2013)

    Oh, this job is great :-D. It's a similar "style" of job as my old one, in that I'm troubleshooting a third-party vendor's software, but the people here...

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

    August 23, 2013 at 5:49 am

    #1644348

  • RE: Help with Max function

    dwain.c (8/22/2013)

    Sql Student-446896 (8/22/2013)

    I want to get the 10.1 and 10.2 in my output. How do i get that?

    Table A has the columns change_id

    Change_id

    -----------

    1.1

    1.2

    2.1

    2.2

    3.1

    3.2

    10.1

    10.2

    There's about a thousand ways in SQL...

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

    August 22, 2013 at 9:16 pm

    #1644232

  • RE: Always Abstract

    RonKyle (8/21/2013)

    I favour moving as much application business logic into stored procedures as is possible, thereby abstracting out the UI layer from the business logic

    I think I can help with...

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

    August 22, 2013 at 8:33 pm

    #1644229

Viewing 15 posts - 26,131 through 26,145 (of 59,102 total)