Forum Replies Created

Viewing 15 posts - 45,736 through 45,750 (of 59,095 total)

  • RE: create view problem

    As a sidebar, there isn't really an advantage to having such an indexed view. The underlying indexes on the table are the only advantage. Indexed views become an...

    --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 20, 2009 at 8:59 pm

    #930055

  • RE: create view problem

    pat (1/20/2009)

    here is the whole table and view scenario

    create table table1

    [pid] [int] IDENTITY(1,1) NOT NULL,

    [num] [int] NULL,

    [flag] [int] NULL,

    [tp_id] [int] NULL,

    [fe_id] [int] NULL,

    [sym] [int] NULL,

    [nvarchar](256) NULL,

    [lbl] [nvarchar](256) NULL,

    [sname] [nvarchar](256)...

    --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 20, 2009 at 8:57 pm

    #930054

  • RE: Hidden RBAR: Triangular Joins

    Apparently, I'm not the only one who has a different "real world" than some and I'm very happy to see that. Everywhere that I've gone, people (including the managers...

    --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 20, 2009 at 8:53 pm

    #930053

  • RE: Hidden RBAR: Triangular Joins

    David.Poole (1/20/2009)

    I understand the argument about not developing for 6 million products because getting a product to market, even with diminished functionality, will allow you to grab the high ground.

    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)

    January 20, 2009 at 8:35 pm

    #930050

  • RE: Hidden RBAR: Triangular Joins

    GSquared (1/20/2009)

    Jeff Moden (1/17/2009)

    ...CLR's are better at most RegEx and file handling. With those two exceptions (so far)....

    The other place I've found CLRs to be "better" is using CLR...

    --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 20, 2009 at 8:33 pm

    #930049

  • RE: Hidden RBAR: Triangular Joins

    Charles Kincaid (1/20/2009)

    I'd much rather say, "Congratulations! Our hardware folks will be calling you but your software is ready to handle the additional load right now.

    YEEE-HAAA! Now we're...

    --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 20, 2009 at 8:29 pm

    #930047

  • RE: Hidden RBAR: Triangular Joins

    LeeBear35 (1/20/2009)

    It is a shame that anyone would cut such corners in project planning and development. Yes you may need to get the software out the door, but I watched...

    --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 20, 2009 at 8:26 pm

    #930046

  • RE: Hidden RBAR: Triangular Joins

    TheSQLGuru (1/20/2009)

    is that real world coders do and always will write suboptimal code

    Maybe when I first get there, but a month or two after I get done training them... viola.

    There'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 20, 2009 at 8:23 pm

    #930043

  • RE: convert DateTime to BigInt

    Chris Morris (1/20/2009)

    Christopher Stobbs (1/20/2009)

    I'm with Jeff on this, why do you need to make the change?

    Because...

    There's no data in the table, although for the purpose of this exercise we...

    --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 20, 2009 at 6:24 am

    #929678

  • RE: VM... Setting up new "box"

    I guess that's why I don't like VM ware... people make decisions for you that they're either not qualified to make or they give you what THEY think is good...

    --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 20, 2009 at 6:13 am

    #929666

  • RE: convert DateTime to BigInt

    munishprathap (1/20/2009)

    thy need only to change the data type Datetime to bigint thts it

    WHY??? This is one of the worst things you can do in a database! And 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)

    January 20, 2009 at 6:00 am

    #929658

  • RE: backup failure

    Ok... create a dummy text file and put it in that same path and run the xp_Dirtree command again.

    --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 20, 2009 at 5:55 am

    #929656

  • RE: create view problem

    pat (1/19/2009)

    it is only numbers and integer it does not contains text!!

    numbers from 1 to atleast 55000

    Thanks

    Just guessing here because we can't see what you can. The only way...

    --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 20, 2009 at 5:53 am

    #929653

  • RE: Timesheets for DBA/DBDs

    Steve Jones - Editor (1/19/2009)

    I wonder if this will come back to bite them later? We had a debate the other day about selling solutions to people that don't know...

    --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 20, 2009 at 5:50 am

    #929649

  • RE: VM... Setting up new "box"

    Successfully launched on 1/16.

    The whole purpose of VM was to be able to react quickly... unfortunately, they don't actually have enough hardware to do what is necessary and that's what...

    --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 20, 2009 at 5:48 am

    #929647

Viewing 15 posts - 45,736 through 45,750 (of 59,095 total)