Forum Replies Created

Viewing 15 posts - 7,426 through 7,440 (of 59,072 total)

  • Reply To: extract all data with week

    Awesome.  Thank you both.

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

    March 30, 2020 at 10:34 pm

    #3739127

  • Reply To: extract all data with week

    My question would be... has anyone run the PowerShell code to make sure it works (with replacements for the table name,  etc, of course)?  I ask because I'm no PowerShell...

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

    March 30, 2020 at 9:00 pm

    #3739096

  • Reply To: Index Optimize

    That would be correct.

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

    March 30, 2020 at 8:56 pm

    #3739095

  • Reply To: Reaping the benefits of the Window functions in T-SQL

    BWAAAA-HAAAA!!!!  There's enough bad code out there for me to be really peeved about that I just don't care where the semi-colon is so long as it's there.  In fact,...

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

    March 30, 2020 at 7:53 pm

    #3739085

  • Reply To: Index Optimize

    Crap... I'm sorry Jeffrey.  I hit "report" instead of "quote" on your post by mistake.

    As for the partitioning, please don't put words in my mouth.  The original decision to partition...

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

    March 30, 2020 at 7:25 pm

    #3739076

  • Reply To: DB Restore is very slow ....

    vsamantha35 wrote:

    Thanks everyone for the help.

    You're welcome but what have you ended up doing?

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

    March 30, 2020 at 2:04 pm

    #3738952

  • Reply To: Importing csv file into SQL table

    schleep wrote:

    See Chad Miller's Powershell function Write-DataTable

    Got a link?

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

    March 30, 2020 at 2:02 pm

    #3738947

  • Reply To: Delete Duplicates from table based on two columns

    Never mind... I misread some code that was written in a strange fashion.

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

    March 30, 2020 at 1:57 pm

    #3738944

  • Reply To: sql server memory buffer cache building up question

    To be honest, I'd be more worried about code that was using "1000's of DB's in production".  Why do you have so many?  Are you using (for example) one database...

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

    March 29, 2020 at 7:49 pm

    #3738742

  • Reply To: Index Optimize

    Jeffrey Williams wrote:

    As for reorganize...there are times when that is the only option available, especially when looking at non-Enterprise Editions that are required to be available 7/24/365 - and you cannot...

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

    March 29, 2020 at 6:02 pm

    #3738734

  • Reply To: DB Restore is very slow ....

    frederico_fonseca wrote:

    Jeff Moden wrote:

    frederico_fonseca wrote:

    thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has...

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

    March 28, 2020 at 5:59 pm

    #3738652

    • Viewing 15 posts - 7,426 through 7,440 (of 59,072 total)