Viewing 15 posts - 1 through 15 (of 135 total)
Thank you for your reply! That is very helpful 🙂 I need to run this purge job once a week but unfortunately I don't know how many rows it will...
December 4, 2019 at 10:01 pm
Thank you for the information. I will look at both the links you provided and keep digging. 🙂
November 13, 2019 at 10:02 pm
Thanks for your reply! So does Visual Studio not work with sftp? Right now the SSIS package just has the ftp setup with the connection manager and it works...
November 13, 2019 at 8:10 pm
That worked perfectly! Thank you again. 🙂
June 21, 2019 at 5:48 pm
So I was able to change the email address but struggled on how to deploy the changes to PRD. The SSIS packages are not stored in the server so there...
June 19, 2019 at 9:47 pm
Thank you! I was able to see he was using a package configuration for his email and was able to make the change successfully. I appreciate your response. 🙂
June 5, 2019 at 4:22 pm
Thank you! That worked perfectly 🙂
March 6, 2019 at 1:07 pm
Thanks for all the feedback. I will test these suggestions as well...always good to learn new things! You guys are awesome 🙂
March 14, 2018 at 9:48 am
Well, that certainly did it. Thank you Lynn...I never would have thought to use the STUFF command. 🙂
(No column name)2018-02-09 16:51:17:002018-02-09 16:51:17:002018-02-09 16:51:17:002018-02-09 16:51:17:00
March 13, 2018 at 4:37 pm
Hi,Thank you for that info. One of the first things I checked was to make sure each server had AlwaysOn still enabled. We noticed this message in the logs:
March 12, 2018 at 6:00 pm
Hi,Based on the fact that it looks like two completely different queries are running for TST and Production, I went ahead and restored the Test database to the 2016...
February 16, 2017 at 5:31 pm
Hi,The query is coming from an application so I have no control over how it is written and I cannot modify it. I am using the same exact query on...
February 15, 2017 at 3:59 pm
Hi, Our production server has 48GB of memory. The test servers only have 16GB of memory and this has a named instance that has 3GB allotted to it. The...
February 13, 2017 at 4:17 pm
Hi Gail,The compatibility level of the test server that completes is SQL Server 2008(100). On the new 2016 and 2012 production server where it never completes, it is 110.
February 13, 2017 at 1:12 pm
Hi,I agree on the comments that MAXDOP is not the solution or that CXPACKETS is the problem. I'm trying to figure out why it's behaving this way on my...
February 13, 2017 at 11:14 am