Forum Replies Created

Viewing 15 posts - 10,111 through 10,125 (of 59,093 total)

  • RE: Insert Faster way

    p.s.  You can also keep the IDENTITY column without a sort by loading up an identical staging table that has no IDENTITY column and then SWITCH it into the table...

    --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 7, 2019 at 12:14 pm

    #2018209

  • RE: Translate Sql Query to Clr

    meryemkurs072 - Monday, January 7, 2019 11:49 AM

    Thank you Jeff, Solomon

    Are there other solutions for query encryption?

    Nothing that a good DBA can't...

    --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 7, 2019 at 12:11 pm

    #2018208

  • RE: Insert Faster way

    RGP - Monday, January 7, 2019 10:21 AM

    Jonathan AC Roberts - Monday, January 7, 2019 9:47 AM

    --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 7, 2019 at 11:44 am

    #2018204

  • RE: Determining uncompressed size when removing Row level table compression

    phil.martin 65477 - Monday, January 7, 2019 8:09 AM

    The table in question has 30million rows and is almost 500GB in size (compressed)....

    --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 7, 2019 at 11:39 am

    #2018202

  • RE: Rebuild index taking time

    RGP - Monday, January 7, 2019 11:11 AM

    Jeff Moden - Thursday, December 20, 2018 10:49 PM

    --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 7, 2019 at 11:31 am

    #2018199

  • RE: How to select the last record added to a table

    BrainDonor - Monday, January 7, 2019 7:53 AM

    --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 7, 2019 at 7:41 am

    #2018165

  • RE: Keep Column Headers Visible in SSRS

    I don't use SSRS but the question of headers does come frequently on these forums.  Now I've got a great place to point them to.  Well done.

    --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 7, 2019 at 6:16 am

    #2018154

  • RE: Synonyms

    Ivanova - Monday, January 7, 2019 1:24 AM

    In a previous role, I used synonyms to allow us to keep a fraud detection...

    --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 7, 2019 at 5:57 am

    #2018153

  • RE: Synonyms

    robert.sterbal 56890 - Sunday, January 6, 2019 9:47 PM

    How many times does the view for a table:

    select * from table_name

    get improved by...

    --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 7, 2019 at 5:51 am

    #2018152

  • RE: Shrink database only x gig a week.

    sundar329 - Monday, January 7, 2019 4:10 AM

    You may use this query to shrink data file.

    declare @src bigint,@sql varchar(250),@filename varchar(25),@shrink bigint
    set @filename='BEL_CDR'--change...

    --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 7, 2019 at 5:36 am

    #2018151

  • RE: Parsing Nested XML file

    Steve Dell - Sunday, December 23, 2018 2:07 AM

    Eirikur Eiriksson - Saturday, December 22, 2018 8:05 AM

    --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 7, 2019 at 4:42 am

    #2018145

  • RE: Determining uncompressed size when removing Row level table compression

    phil.martin 65477 - Monday, January 7, 2019 4:25 AM

    Brilliant thanks. Worked a treat

    So you're saying that going from Row Compression to 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)

    January 7, 2019 at 4:33 am

    #2018142

  • RE: Update stats

    RGP - Sunday, January 6, 2019 5:28 PM

    I have a sql agent job that runs update stats every day actually every 5...

    --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 7, 2019 at 4:15 am

    #2018136

  • RE: Translate Sql Query to Clr

    Solomon Rutzky - Sunday, January 6, 2019 2:59 PM

    I also recommend to Jeff to do the same (i.e. update his reply...

    --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 7, 2019 at 3:44 am

    #2018131

    • Viewing 15 posts - 10,111 through 10,125 (of 59,093 total)