Forum Replies Created

Viewing 15 posts - 26,431 through 26,445 (of 59,099 total)

  • RE: need solution and feedback to the below question!!

    Steven Willis (7/15/2013)

    Perhaps an even simpler solution:

     

    That would have been my first choice for this. I believe that I'd reverse the order of the tables, though. Reason being...

    --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 15, 2013 at 9:58 pm

    #1632739

  • RE: Hiring Guitarists

    jfogel (7/15/2013)

    One of the major apps our business uses names columns with spaces and special characters like "Created Date/Time". I'm surprised they don't want the case sensitivity default changed as...

    --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 15, 2013 at 9:25 pm

    #1632735

  • RE: archive process

    Chrissy321 (7/15/2013)

    Here is one example.

    http://www.sqlservercentral.com/articles/transactions/69132/

    Careful now... that's a full up RBAR solution even if there are batches of rows being processed. I'd really hate to see someone fall into...

    --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 15, 2013 at 8:36 pm

    #1632729

  • RE: archive process

    Hmmmmm..... I just had a thought and have to take back the "there's nothing faster". Can you use BCP and is there a commond folder that both servers can...

    --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 15, 2013 at 8:26 pm

    #1632728

  • RE: archive process

    riya_dave (7/12/2013)

    well archiving in the sense i need to dump 1 year data from 1 database to another.

    but the problem is i have 60 million rows and i need 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 15, 2013 at 8:24 pm

    #1632727

  • RE: The Desktop

    anon_tyrant (7/15/2013)

    RDP is the real tool, laptop is only needed if you need to connect somewhere besides home or work. I finish up work at 5, go home 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)

    July 15, 2013 at 7:49 pm

    #1632724

  • RE: Hiring Guitarists

    jfogel (7/15/2013)

    Of course a postal code field should be nvarchar(4000)! You never know what the future holds.

    BWAAA-HAAAA!!!! That and an "IsActive" column were the examples I used put put...

    --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 15, 2013 at 7:46 pm

    #1632723

  • RE: Using a Recursive CTE to Generate a List

    jennym (7/15/2013)

    Agree completely, but wasn't sure a better alternative (the excel method has been worse for users than the CTE method so far). What would you recommend, assuming no...

    --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 15, 2013 at 7:37 pm

    #1632721

  • RE: Hiring Guitarists

    L' Eomot Inversé (7/15/2013)

    and yes I've met one or two (certainly fewer than three) in almost half a century or working in computing/compute science/IT/whatever you want to call it who...

    --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 15, 2013 at 7:26 pm

    #1632719

  • RE: Using a Recursive CTE to Generate a List

    jennym (7/15/2013)

    Thanks for the well written, clear, and simple tutorial. I use CTE's a lot as they've proven very useful when needing to manipulate data without write access 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)

    July 15, 2013 at 12:41 pm

    #1632637

  • RE: How to take backup of Single table and how to restore?

    Vlad-207446 (7/15/2013)

    it's strange that no one asked a fairly obvious question(s) as

    #1. why exactly OP needs to backup single table?

    #2. what is the reason for such need and how...

    --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 15, 2013 at 12:21 pm

    #1632627

  • RE: The Desktop

    chris-945648 (7/15/2013)

    Wasn't this problem solved by docking stations?

    Kind of... in our company, you're not allowed to leave a laptop in an open area after hours. You HAVE to take...

    --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 15, 2013 at 12:12 pm

    #1632626

  • RE: Hiring Guitarists

    patrickmcginnis59 10839 (7/15/2013)

    Vila Restal (7/12/2013)

    That's a sweeping generalisation of 'coders' (or perhaps more respectfully called software engineers or developers). Do you really have so little respect for them all, even...

    --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 15, 2013 at 12:07 pm

    #1632621

  • RE: Clustered Index Ordering & Insert Speeds

    shing.lau (7/14/2013)

    Hi,

    We used to have a clustered index which consisted of 5 fields, this was ordered incorrectly which meant new inserts caused a lot of bad page splits.

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

    July 14, 2013 at 11:22 pm

    #1632293

  • RE: The Desktop

    CC-597066 (7/14/2013)

    I have a work laptop but it never leaves the office and very rarely gets logged off. I use Citrix or VPN/RDP to connect to it from my own...

    --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 14, 2013 at 11:15 pm

    #1632292

Viewing 15 posts - 26,431 through 26,445 (of 59,099 total)