It's been almost 10 years since I have had to deal with this, but my rusty memory and a quick google makes me think I'm giving decent advice.

I believe there's...

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

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

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

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

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

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

@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 5 years ago by  Greg Goss.

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

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

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

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

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

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

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