Viewing 15 posts - 1 through 15 (of 174 total)
Great article, thank you!
I think this sentence has a typo: "Now we have a Seek Predicate on DateAdded and a Predicate filter on DelFlag with a much-improved query cost (and...
September 16, 2020 at 12:33 am
I don't have a good reason for not having environment folders. I think it was just on oversight on our part.
July 10, 2020 at 9:58 pm
Phil, thank you very much for taking the time to write these queries and I apologize for the delay in replying (works gets in the way of my fun :)...
July 8, 2020 at 11:01 pm
Thank you! We do all of our deployments via SSISB catalog (that's why I asked the question). I thought this was now the Microsoft-recommended way of doing things....
June 24, 2020 at 5:05 pm
Thank you! We do all of our deployments via SSISB catalog (that's why I asked the question). I thought this was now the Microsoft-recommended way of doing things. We do...
June 23, 2020 at 11:18 pm
Thank you for the article and sharing your code and research. While working on it, have you encountered solutions, which do similar things for the packages stored in SSISDB? It...
June 23, 2020 at 10:38 pm
Thank you for the article. I found it useful.
Listings 6 and 9 (it's the same code) are missing BEGIN TRANSACTION statement.
June 12, 2020 at 10:44 pm
Can somebody comment on how this compares to using the T-SQL-t framework. I have only a general idea about, but haven't used it in the real world.
January 5, 2020 at 8:53 pm
We also ran into issues with SSISDB clean-up job once we had a large number of packages and executions. The built-in mechanism didn't work no matter how much we played...
December 26, 2019 at 8:31 pm
Hello Pamela! Thank you for the article. I do have one question. In the query, which collects the table row counts, you have this in the SELECT clause: SUM(ps.row_count) AS...
August 1, 2019 at 10:32 pm
This brought back some not-so-fond memories of working with Excel/Access and all their limitations. I guess I've been fortunate to be working with "real" databases over the last decade or...
May 18, 2018 at 2:20 pm
April 20, 2018 at 11:32 am
I get a red squiggly line under this statement:using System.Data.SqlClient;the hint says "the type or namespace SqlClient does not exist in the namespace System.DataTried adding references to...
April 20, 2018 at 9:15 am
Great article. Thank you for sharing your approach.Can you explain the acrobatics done here. I don't understand the reason for using tempList variableforeach (string...
November 10, 2017 at 1:55 pm
Great article, thank you!P.S. If somebody would proofread it before publishing it would be even better :satisfied:
October 29, 2017 at 2:07 pm