Viewing 15 posts - 1 through 15 (of 34 total)
Thanks for the suggestions. We do have a homemade PowerShell script as well that mimics our desired settings, so we could use that rather than scripting from SSMS. I'll also...
February 26, 2024 at 9:50 pm
Unfortunately, no. We scrapped the upgrade to 2019 and instead only upgraded to 2017. If you end up figuring out a solution (other than regenerating the packages or manually fixing...
November 10, 2020 at 2:58 am
Hi Mike,
Unfortunately I wasn't able to find any clear documentation online about the consequences of not setting TargetServerVersion to 2019. We tried keeping the target server version at 2017 even...
June 15, 2020 at 3:52 pm
I see, thanks - that was the problem!
November 15, 2019 at 6:55 pm
Thanks Andreas and Sue. From what I can tell, the "Disk Usage by Table" reserved space does include unused space. That report has 4 columns: Reserved, Data, Indexes, Unused. The...
September 12, 2018 at 9:00 am
July 20, 2018 at 12:35 pm
Here's some additional info that might be helpful. I was following the blog post here on serial vs. parallel optimization thresholds.
Here is info from the final...
July 20, 2018 at 11:21 am
July 20, 2018 at 10:15 am
July 20, 2018 at 9:16 am
July 17, 2018 at 10:51 am
July 16, 2018 at 8:10 am
July 16, 2018 at 7:23 am
I figured out the problem, and I feel a little stupid that it took so many hours to figure out. But I'll post in case anyone else happens to come...
May 30, 2018 at 11:42 am
Jo Pattyn - Saturday, May 26, 2018 8:14 AMAll the packages of the project are checked out?
Yes, all of the packages, the...
May 29, 2018 at 1:55 pm
May 25, 2018 at 2:32 pm
Viewing 15 posts - 1 through 15 (of 34 total)