Viewing 15 posts - 1 through 15 (of 429 total)
Even Microsoft has not been able to make any progress on this. We are stuck at the same point. SSIS is able to write to disk with 20+ MB\sec when...
September 22, 2020 at 4:18 pm
can't think of much more - except - is the output filename UNC or Drive letter based? if UNC change it to local drive .
Only the package and its...
August 27, 2020 at 1:59 pm
I would try and change from executing a SSIS step (which seems to be what you are doing) to execute a command line instead - see if it makes...
August 26, 2020 at 5:59 pm
Hello Folks,
Same package with same options (picked from SQL Server Agent command line only) is run manually by opening a command prompt and invoking DTexec utility, the destination...
August 26, 2020 at 2:33 pm
Issue got resolved after we ran sp_refreshview
I believe we needed to do this post SQL Server Upgrade to SQL 2014.
Sometimes we miss simple things.
January 10, 2019 at 10:28 am
I am trying to see if an indexed view can be created and benefit the query. Because except parallelism, I don't see any other wait type for this query.
January 10, 2019 at 7:52 am
Thom A - Wednesday, January 9, 2019 7:16 AMDoes your VIEW (XF_GISFPF_History_Security_vw and XF_GISFPF_History_Instrument_vw) need to use UNION rather than UNION ALL.
I...
January 9, 2019 at 7:38 am
It looks like you're selecting data from views...
January 9, 2019 at 7:08 am
January 7, 2019 at 8:11 am
You're not misunderstanding a thing. I agree that the "500 rows" being returned...
January 4, 2019 at 6:38 am
January 3, 2019 at 11:02 am
I can see why (although I don't necessarily agree but "It Depends") they...
January 3, 2019 at 9:23 am
January 3, 2019 at 8:04 am
Viewing 15 posts - 1 through 15 (of 429 total)