Forum Replies Created

Viewing 15 posts - 1,486 through 1,500 (of 59,082 total)

  • Reply To: Log File continue growing

    My apologies... I don't use any of the things that use the log file of a database so I don't actually know what else to check on this issue.  My...

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

    May 10, 2023 at 2:17 pm

    #4187422

  • Reply To: Index Spool Eager Pool issue

    If partitioning IS present, why is there a need for any of this?  SWITCH the old data out.  Copy it to a new table in the archive.  Then SWITCH 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)

    May 10, 2023 at 1:13 pm

    #4187394

  • Reply To: Want to load data on a staging table.

    Teewhy wrote:

    I will want to have this solution in my arsenal. What is the code to install ACE Drivers? How do I set it up?

    Please, show me easy and step...

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

    May 10, 2023 at 12:56 pm

    #4187383

  • Reply To: Want to load data on a staging table.

    David Burrows wrote:

    Jeff Moden wrote:

    homebrew01 wrote:

    Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.

    I'm pretty sure that BCP doesn't work on actual spreadsheets...

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

    May 9, 2023 at 7:11 pm

    #4186848

  • Reply To: System versioned tables permissions

    I think the answer is "because".  😉  I've not checked privs on system versioned temporal tables before but it may very well be that if the user has write privs...

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

    May 9, 2023 at 7:02 pm

    #4186842

  • Reply To: Log File continue growing

    datkop wrote:

    Thanks for the advice.

    So i read this before and did a log backup.

    Backup Type: Transaction Log

    It doesnt work... Or do you mean anything else?

    Edit: So i turned the log...

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

    May 9, 2023 at 6:55 pm

    #4186836

  • Reply To: Log File continue growing

    If you look for the accepted answer at the following link...

    https://social.msdn.microsoft.com/Forums/en-US/1fb51bb5-a09f-4bd6-8880-4f0c15227db5/what-does-it-mean-when-dbcc-loginfo-returns-many-rows-with-status-2-and-dbcc-opentran-returns-no?forum=sqldatabaseengine

    ... it says...


    Status = 2 means that VLF can't be reused (overwritten) at this time and 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)

    May 9, 2023 at 6:07 pm

    #4186809

  • Reply To: Want to load data on a staging table.

    homebrew01 wrote:

    Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.

    I'm pretty sure that BCP doesn't work on actual spreadsheets ((but I...

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

    May 9, 2023 at 5:57 pm

    #4186806

  • Reply To: Dirty Reads with Read Committed?

    AVB wrote:

    Hi Jeff,

    Thanks for the reply.

    It only deletes some of the data. Also, the query that isn't returning data only pulls from that subset that gets deleted.

    Those rows are locked...

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

    May 9, 2023 at 5:55 pm

    #4186805

  • Reply To: Employee count based on target date

    samservice wrote:

    I have table for employee activity with the following fields:

    [Emp ID] , [Hire Date] , [Term Date] , [Mod Date] , [Old Div] , [New Div]

    When an employee is...

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

    May 9, 2023 at 5:52 pm

    #4186804

  • Reply To: how to get previous year and current year data in coma separated values in sql

    kbhanu15 wrote:

    Hi Ratbak,

    Thanks for your reply but order is the only my main problem.

    --Expected o/p : Previours years following by current year data --Jan-2022,January-2022,Jan-2023,01-01-2023,Jan-2023,Jan-2023

    Thanks

    Bhanu

    Since this seems new to you, read...

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

    May 9, 2023 at 5:45 pm

    #4186801

    • Viewing 15 posts - 1,486 through 1,500 (of 59,082 total)