Forum Replies Created

Viewing 15 posts - 45,751 through 45,765 (of 59,101 total)

  • 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

  • RE: Opening & Closing Stock Problem

    tevers (1/19/2009)

    So that's how outsourcing works!! The project goes to India and someone posts it as a question and then sends the answer back. Although I think 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)

    January 20, 2009 at 5:42 am

    #929640

  • RE: Bulk Insert

    Larry Mitchell (12/27/2007)

    Just double checked. No security issues.

    The part that's throwing me off is the other dbs are working fine. The process that hits those databases is using 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)

    January 20, 2009 at 5:36 am

    #929633

  • RE: OpenRowset Query

    jacowess,

    Look at my previous post and look at your original post. If that's what you're actually running, you have syntax errors in the code.

    --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:34 am

    #929628

  • RE: Why do people need to do this?

    Jacob Luebbers (1/19/2009)

    Jeff Moden (1/19/2009)

    ...but would you need to restart the numbering each time a customer changes (or other thing) within the same day as in the original data 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 5:23 am

    #929619

  • RE: convert DateTime to BigInt

    munishprathap (1/19/2009)

    Thanks Jeff

    according to my requirement i need to keep the one column type as bigint but unfortunately

    i keep it as DateTime after long time i found that it was...

    --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:19 am

    #929615

  • RE: create view problem

    Well... does it?

    --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 19, 2009 at 8:32 pm

    #929471

  • RE: Why do people need to do this?

    smunson (1/19/2009)

    Jeff,

    After 30 years of having to find ways to get data in or out of computer systems for almost every conceivable purpose, what I've found is that in every...

    --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 19, 2009 at 8:30 pm

    #929470

  • RE: backup failure

    mohinidba (1/18/2009)

    Hi this is cluster server .Inthis backup was failed with the erro

    can not open the following files

    t;\michrosoftsqlserve\mssql.1\mssql\data

    all of the data files of the system dbs and user dbs.

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

    January 19, 2009 at 7:54 pm

    #929463

  • RE: OpenRowset Query

    Ummm... what happens when you run just the SELECT?

    select NonEmpty [Tests].[Fixed] on columns,

    from Cube

    where ([Test Date].[Date].&[2009-01-16T00:00:00]

    I'm thinking that you have some illegal text in the where clause and you're missing...

    --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 19, 2009 at 7:46 pm

    #929459

Viewing 15 posts - 45,751 through 45,765 (of 59,101 total)