Forum Replies Created

Viewing 15 posts - 42,826 through 42,840 (of 59,098 total)

  • RE: Index Fragmentation...

    Why not just use DBCC SHOWCONTIG and save it in a table?

    Also, most folks might be able to live with 30% fragmentation, but I can't... the tables I work 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)

    July 22, 2009 at 10:31 pm

    #1028758

  • RE: CLR Fail to load

    jqd2001 (7/22/2009)

    Unless it has to do with effecient RegEx, I've not known that to be true. It would be interesting to try to solve your problem with a T-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)

    July 22, 2009 at 10:25 pm

    #1028755

  • RE: SQL View

    frecal (7/22/2009)

    Hi Jeff

    that would be the correct way of recording it but probably over kill for what i am needing it for.

    I am working on a data linkage project 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 22, 2009 at 10:12 pm

    #1028752

  • RE: how to degrade a database schema from 2005 to 200

    Remove all of the WITH hints except for the Fill Factor.

    I can't believe this isn't handled automatically when you tell it to gen the script as SQL Server 2000.

    --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 22, 2009 at 9:52 pm

    #1028751

  • RE: Passing Stored Procedures "values" for IN

    There are a whole lot of split functions... with extremely rare exception, if it uses a While Loop, it's slow. Don't even look at one that uses an XML...

    --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 22, 2009 at 9:48 pm

    #1028750

  • RE: DBA's and Developers

    There are two basic types of DBA's and they've both been described in this thread. Big corporation or small, these two types of DBA's can and do exist. ...

    --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 22, 2009 at 9:39 pm

    #1028749

  • RE: Flat file to Table

    John Rowan (7/22/2009)

    OK, here's what I'd do:

    Create a Data Flow with the following contents:

    1. Flat File Source adapter to get your file info into the data flow.

    2. Lookup Transform. ...

    --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 22, 2009 at 9:32 pm

    #1028748

  • RE: Data Import

    To the best of my knowledge, you can't. You can certainly use SSIS or DTS to transfer tables and data, but some of the datatypes won't be what you'd...

    --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 22, 2009 at 9:26 pm

    #1028747

  • RE: Index scan hint

    SQL Guy (7/22/2009)

    Hi.

    In my script, the execution plan chose index seek in one case, but I want to test it with scan without changing the index itself (because I have...

    --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 22, 2009 at 9:18 pm

    #1028746

  • RE: Index scan hint

    Lynn Pettis (7/22/2009)

    Why? Seeks are faster than scans.

    Heh... because "A developer must not guess... a developer must KNOW." 😉 It'll be a nice test.

    --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 22, 2009 at 9:17 pm

    #1028745

  • RE: How do I change the structure of a table with data in it?

    Folks are making it pretty hard on themselves for such a simple thing...

    Just go to the DESIGN mode for the table and make whatever changes you need to. Obviously,...

    --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 22, 2009 at 9:15 pm

    #1028744

  • RE: tsql to store converted values

    On second thought, UNPIVOT is a real PITA to code dynamically. Here's a much simpler method that you can use. I've got it setup to do an existing...

    --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 22, 2009 at 9:01 pm

    #1028742

  • RE: tsql to store converted values

    lpatrick (7/22/2009)

    Thanks for the quick response!

    My next question is how I get the column name to put in the 'unpivoted' data.

    And nextly (I think this is 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)

    July 22, 2009 at 7:33 pm

    #1028732

  • RE: Are the posted questions getting worse?

    . (7/22/2009)

    seems a tad mean

    Yeah I know, but it took me literally under 1 minute to convert his table2 post into real code that I could work with. 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)

    July 22, 2009 at 10:51 am

    #1028518

  • RE: Problem with Query

    ChandraMohan Nandula (7/22/2009)

    I know that this is not the correct format to post.

    Heh... since you don't care, neither do I. Have a nice day. 😉

    --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 22, 2009 at 10:44 am

    #1028516

Viewing 15 posts - 42,826 through 42,840 (of 59,098 total)