Forum Replies Created

Viewing 15 posts - 1 through 15 (of 67 total)

  • Reply To: SSIS Send Mail task permissions

    Bojdar,

    It appears that would have been the issue were it not for the fact that the very same package can generate the file to begin with.  It was acting like...

  • Reply To: Uncommitted implicit transactions

    Sue,

    You are correct in that I wanted a definitive list, but I'm perfectly fine knowing that it can be a little fluid.  Based on what you are saying and what...

  • Reply To: Uncommitted implicit transactions

    Stored procs, good call.  I'll check there!   And I know this seems obvious, but if I run dbcc opentran or look in sys.dm_tran_active_transactions and see "implicit_transaction" as the name, then...

  • Reply To: Uncommitted implicit transactions

    Okay, so if I'm understanding this correctly, the implicit options option is not checked in my connection properties for the server then by default implicit transactions are off when connections...

  • Reply To: Very large t-log with backups

    As a closure to this conversation, I think I've been able to isolate where my growth is coming from.  While the index issues mentioned are present and need to be...

  • Reply To: Very large t-log with backups

    Looking at the data, the B2GRT column can only have 3 values ('','Y','Z').  So the default value seems to be enforced by the app and is an empty string, not...

  • Reply To: Very large t-log with backups

    @JeffModen,

    Okay, I know it took longer than expected, but I finally got my hands on the code that updates that table.  Here's the process.  Once a record has been marked...

    • This reply was modified 1 year, 3 months ago by  Greg Goss.
    Attachments:
    You must be logged in to view attached files.
  • Reply To: Very large t-log with backups

    The TEST database is about 130GB (roughly half data, half index).  I'll need to restore PROD to TEST again to test more reindexing scenarios since TEST isn't used much and...

  • Reply To: Very large t-log with backups

    Jeff, I'm always game to learn how to better finesse my databases into submission 🙂  If I could get this under control it would help my reporting and analysis processes...

  • Reply To: Very large t-log with backups

    What I've read here and what I'm seeing in my system, it's definitely the weekly index defrag that is the culprit.  I have been using the Hallengren reindex script and...

  • RE: Suspected bad data in table

    I'm only guessing at your intent based on the vagueness of the question, but I took it to mean that you are seeing some strange behavior in an application of...

  • RE: How to convert this procedure as dynamic SQL

    Phil Parkin (4/8/2016)


    Greg A Goss (4/8/2016)


    Without knowing anything else about the application/process/environment, what if you created the stored proc in the order database (the one that changes names) and...

  • RE: How to convert this procedure as dynamic SQL

    Without knowing anything else about the application/process/environment, what if you created the stored proc in the order database (the one that changes names) and then reference the lookup database (which...

  • RE: How to convert this procedure as dynamic SQL

    If you're calling it from an SSIS package, as long as the stored procedure name itself isn't changing, then the connection you've defined will determine which database it is executed...

  • RE: How to convert this procedure as dynamic SQL

    I apologize greatly if I'm just blind and am missing it, but I don't see where the database is specifically mentioned within the stored procedure. Where exactly would you...

Viewing 15 posts - 1 through 15 (of 67 total)