Viewing 15 posts - 1 through 15 (of 28 total)
I may have missed something, but from the plan it appears that the 2nd...
October 19, 2018 at 12:21 pm
Many thanks Dear DesNorton for your time:
As I mentioned before all the objects are identical (now) after I added a missing (unneeded) index
ActivityType PK_ActivityType CLUSTERED 1 1 0 LicenseeId,ActivityTypeId NULL NULL
ActivityType ix_ActivityType_ExternalId NONCLUSTERED 0 0 0 LicenseeId,ExternalId NULL NULL
October 19, 2018 at 12:12 pm
anvegger - Friday, October 19, 2018 8:18 AMGood point - I do my best to check it out Thanks Jeff!
Used a...
October 19, 2018 at 9:18 am
October 19, 2018 at 8:25 am
Jeffrey Williams 3188 - Friday, October 19, 2018 8:09 AMBefore you do that try schema qualifying all tables in the query.
Good point...
October 19, 2018 at 8:18 am
Yes you right Jeff - my next logical step would be to sync data in both cases (databases) and make sure that I eliminate or prove the impact of a...
October 19, 2018 at 7:57 am
BTW that INDEX hint along with an INDEX itself did not change execution plan or stats - simply used a different index to produce the same amount of data consuming...
October 19, 2018 at 7:16 am
October 19, 2018 at 6:55 am
October 19, 2018 at 6:47 am
October 19, 2018 at 6:43 am
Schedule 175982 45016 KB 22904 KB 21928 KB 184 KB -- Database A
Schedule 179796 46136 KB 23384 KB 22344...
October 18, 2018 at 6:46 pm
October 18, 2018 at 6:45 pm
October 18, 2018 at 6:30 pm
October 18, 2018 at 6:24 pm
That would of been my thought as well but unfortunately I don't see that right in front of my query: everything looks very strait forward - especially the root :...
October 18, 2018 at 4:33 pm
Viewing 15 posts - 1 through 15 (of 28 total)