Viewing 15 posts - 16 through 30 (of 43 total)
Found the issue and thought I would post her so people would not wonder.
The answer turned out to be simple. I was thinking about the reply by Jeff Moden...
January 10, 2013 at 3:51 pm
Oh there would be no guarantee of a fix. This is being communicated as a tourniquet or a splint - just enough to stop the bleeding and get us home....
January 9, 2013 at 8:34 pm
GilaMonster (12/17/2012)
What indexes are on the RecordID, WorkstationOID and trackingnumber columns?Do you really need to have multiple update triggers on the same table? Can they not be combined into one?
There...
December 17, 2012 at 3:18 pm
We have very harsh change control rules. I will have to check to see if that can be performed as part of our troubleshooting. I have to say I ignored...
December 17, 2012 at 12:49 pm
Well, I was hoping I could avoid putting the whole thing up here. I tried to include everything but the code. There is already a separate plan to re-evaluate and...
December 17, 2012 at 8:48 am
To answer your questions:
Phil:
Is the data flow just doing a straight INSERT, or are updates (or some other processing) involved too?
Is Data Access Mode set to 'Table or View...
November 15, 2012 at 10:53 am
Thanks for the replies. The DBA has already helped us with the basic tuning stuff like indexes and statistics and I do see that 'NOLOCK' should not be used in...
April 11, 2012 at 12:29 pm
Thanks for your reply.
The problem has been identifying the 1 mil records to copy over in the first place. We don't currently have a way of tracking the changes...
September 26, 2011 at 12:23 pm
As with everything else - It Depends.
Sometimes with weak managers, I find myself becoming the defacto manager of myself. I make the priorities, defend myself and teammates, and, if necessary,...
August 26, 2011 at 7:48 am
That is correct. However, here is an update:
Rebuilt parent package from scratch. 2 out of the 3 packages now launch as expected. The 3rd does not launch and an...
June 27, 2011 at 6:46 am
No. Much simpler than that. It is a custom table that just lists the rowid, package name, type of logging and datelastset. The connection information for the log table is...
June 24, 2011 at 6:39 am
Thanks for your reply. The reason is to be able to customize the logging on the fly. I can completely control the log entry and when it fires on the...
June 24, 2011 at 6:12 am
I would say the tactical question here is using cloud as primary and having backups vs. having primary onsite with cloud as hot secondary with backups vs. cloud as primary...
May 5, 2011 at 9:26 am
Nice job sniffing that one out. That little tip will make me look like a super SQL expert with the boss as I am sure that if anyone here has...
April 27, 2011 at 5:53 am
Chris-354050,
Look a little closer at the article. The laptop connection study was a separate study from the one where they tested bluetooth and music files.
As far as the...
March 23, 2011 at 7:15 am
Viewing 15 posts - 16 through 30 (of 43 total)