Forum Replies Created

Viewing 15 posts - 32,401 through 32,415 (of 59,099 total)

  • RE: Taking Risks

    Ben Moorhouse (10/3/2011)

    No offence, but who said anything about switching between versions?

    In my mind, 2008 > 2005 isn't a proper backup.

    I have 2005 backing up to a 2005 box 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)

    October 3, 2011 at 6:09 am

    #1389441

  • RE: Taking Risks

    Heh... have you ever tried to restore a 2k8 backup back into a rebuilt 2005 server after a couple of days when you find out some of the lesser used...

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

    October 3, 2011 at 5:48 am

    #1389430

  • RE: Taking Risks

    Ok... you good folks and "risk" takers that have posted so far... 😉

    How many of you are actually willing to install a new product (or even "just" a switch from...

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

    October 3, 2011 at 5:37 am

    #1389424

  • RE: Best approach to import text file?

    Can you attach the file that you're trying to import? Please... make sure there's no one's private information if you do.

    Also, thank you for posting the BCP error but...

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

    October 3, 2011 at 5:12 am

    #1389410

  • RE: Data Grouping

    ColdCoffee (10/1/2011)

    How about this Jeff ???

    That's some sharp code, CC. Well done. However, shorter code using "new" stuff like ROW_NUMBER() isn't always better. Please consider the following...

    --=============================================================================

    --...

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

    October 3, 2011 at 4:57 am

    #1389402

  • RE: Data Grouping

    SQL_By_Chance (10/2/2011)

    I think in the given scenario Jeff's solution with CTE is best possible.

    But in case you want to dwell in subqueries. Can you please post the result that...

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

    October 3, 2011 at 4:52 am

    #1389399

  • RE: Best approach to import text file?

    Look at the example the OP gave, Andre... each element is on a single row with row indicators between "whole records". You don't need a splitter for 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)

    October 2, 2011 at 8:03 pm

    #1389265

  • RE: Are the posted questions getting worse?

    Lynn Pettis (9/30/2011)

    Okay, for $250 - $750 USD I want the following:

    Need Software with following modules and features...

    If you are willing to to do this, go here.

    I can understand 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)

    October 2, 2011 at 7:26 pm

    #1389258

  • RE: Are the posted questions getting worse?

    Jack Corbett (10/1/2011)

    Hey guys I got some really cool news today. I was awarded MVP status!

    I just hope I can honor that award the way that all the MVP'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)

    October 2, 2011 at 7:18 pm

    #1389257

  • RE: HierarchyID performance problems... Really???

    Thanks, Peter. Ironically, that was one of the "dead ends" I ran across in my search for performance problems and I'm definitely not seeing those types of problems in...

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

    October 2, 2011 at 2:40 pm

    #1389246

  • RE: Taking Risks

    Ah... sorry, Brad... I have to disagree with you on most of what you said except for "pushing a change to production without testing it first on a test server,...

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

    October 2, 2011 at 2:01 pm

    #1389239

  • RE: CTE

    A CTE is really nothing more than a "Derived Table" (sub-SELECT) which you would find in a FROM clause whose result set is being used as a table.

    The two things...

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

    October 2, 2011 at 1:48 pm

    #1389237

  • RE: Best approach to import text file?

    codebyo (10/1/2011)

    Now if you need to pass the filename as a variable you won't be able to use OPENROWSET that way. It needs a constant value as filename.

    But you could...

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

    October 2, 2011 at 1:36 pm

    #1389236

  • RE: Best approach to import text file?

    vince_sql (10/1/2011)

    Jeff Moden (10/1/2011)

    BCP with a format file that uses the end of line characters as delimiters (as well as some others).

    In actuality, that's not the "best" way... the absolute...

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

    October 2, 2011 at 1:31 pm

    #1389235

  • RE: Need date: Today - 2 years..

    calvo (9/27/2011)

    Cadavre (9/27/2011)

    calvo (9/27/2011)

    Have you checked that link? There's all the date conversions and date manipulations you'll ever need there.

    DATEADD(YEAR,-2,cast(CURRENT_TIMESTAMP as DATE))

    Just to prove that I do listen when I'm...

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

    October 2, 2011 at 12:31 pm

    #1389226

Viewing 15 posts - 32,401 through 32,415 (of 59,099 total)