Viewing 15 posts - 1 through 15 (of 67 total)
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...
September 8, 2020 at 5:55 pm
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...
February 4, 2020 at 2:04 pm
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...
February 3, 2020 at 9:14 pm
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...
February 3, 2020 at 7:42 pm
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...
February 3, 2020 at 6:47 pm
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...
November 11, 2019 at 9:38 pm
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...
November 11, 2019 at 7:16 pm
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...
October 29, 2019 at 6:59 pm
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...
October 29, 2019 at 12:57 am
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...
October 28, 2019 at 2:41 pm
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...
May 17, 2017 at 8:54 am
Phil Parkin (4/8/2016)
Greg A Goss (4/8/2016)
April 8, 2016 at 11:46 am
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...
April 8, 2016 at 11:32 am
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...
April 8, 2016 at 9:59 am
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...
April 8, 2016 at 9:56 am