User profile for Andrew P

Hello Shrek, Thanks for posting and I am sorry if this is causing you any issues! A table with a nonclustered columnstore index is read-only until the index is dropped or disabled. To update the table and the nonclustered columnstore index you can switch partitions in and out. You can also disable the index, update the table, and then rebuild the index. We take the latter route most likely because it seems to be the least memory intensive operation. There is no way to bypass this behavior at present. Here is a msdn article on columnstore Indexes https://msdn.microsoft.com/en-us/librar ... x#dataload and specifically on nonclustered columnstore indexes https://msdn.microsoft.com/en-us/librar ... spx#change I hope that was helpful! I will follow up with you via email for more Q and A. Warm Regards, Andrew Pierce Redgate Support Engineer / comments

Hello Shrek, Thanks for posting and I am sorry if this is causing you any issues! A table with a nonclustered columnstore index is read-only until the index is dropped or disabled. To update the ta...

0 votes

Hello! Thanks for contacting us! My answer is that it probably will not pick up that information (since it currently cannot look into outside applications for dependencies), however you can quickly try downloading it and opening the database to see if it will pick up this info. I will follow up with you via email to try to get this sorted. Cheers! Andrew Pierce Product Support Engineer Redgate / comments

Hello! Thanks for contacting us! My answer is that it probably will not pick up that information (since it currently cannot look into outside applications for dependencies), however you can quickly...

0 votes

Hello Tom, Thanks for posting your question! We will follow up with you via email to further troubleshoot and resolve this. Warmly, Andrew Pierce Product Support Engineer Redgate / comments

Hello Tom, Thanks for posting your question! We will follow up with you via email to further troubleshoot and resolve this. Warmly, Andrew Pierce Product Support Engineer Redgate

0 votes

Thanks for your query! You can change the file name and it is right next to the timestamp checkbox. I have followed up with you via email with some pictures of what I mean. Warmly, Andrew Pierce Product Support Engineer / comments

Thanks for your query! You can change the file name and it is right next to the timestamp checkbox. I have followed up with you via email with some pictures of what I mean. Warmly, Andrew Pierce Pr...

0 votes

Hello, Thanks for contacting us! We will be following up with you via email to work through this issue. Warmly, Andrew Pierce Product Support Engineer Redgate Software / comments

Hello, Thanks for contacting us! We will be following up with you via email to work through this issue. Warmly, Andrew Pierce Product Support Engineer Redgate Software

0 votes

Hello Vijay and Brendan, Thanks for contacting us, and thank you Brendan for helping answer this question! [image] The documentation page that Brendan linked is the main method to mask columns within your database. It seems that I do not have Vijay's email address, but if you have any questions or issues you can reply to this or submit a request to support@red-gate.com. Thanks! Warm Regards, Andrew Pierce Product Support Engineer Redgate Software / comments

Hello Vijay and Brendan, Thanks for contacting us, and thank you Brendan for helping answer this question! The documentation page that Brendan linked is the main method to mask columns within you...

0 votes

Hello Dale, Thanks for posting your question. We will follow up with you via email to resolve this. Warmly, Andrew Pierce Product Support Engineer Redgate Software / comments

Hello Dale, Thanks for posting your question. We will follow up with you via email to resolve this. Warmly, Andrew Pierce Product Support Engineer Redgate Software

0 votes

Hello Sjacker, Thanks for reaching out to us! Currently you cannot specify a custom delimiter within Multiscript, but you might be able to output to a .csv file then do a "Find And Replace All" with Notepad++ to get the formatting right. In any case I have submitted a feature request SE-684, so it is up to the project managers to triage accordingly. Please let me know if you have any questions. Warmly, Andrew Pierce Product Support Engineer - Redgate / comments

Hello Sjacker, Thanks for reaching out to us! Currently you cannot specify a custom delimiter within Multiscript, but you might be able to output to a .csv file then do a "Find And Replace All" wit...

0 votes

Hello John, Thanks for reaching out to us! Currently you cannot save all of the field descriptions simultaneously, I have added it as feature request number SDOC-1652 so it is up to the project managers to triage it appropriately. Please reach out to me if you would like an update, or have any questions. Warmly, Andrew Pierce Product Support Engineer- Redgate / comments

Hello John, Thanks for reaching out to us! Currently you cannot save all of the field descriptions simultaneously, I have added it as feature request number SDOC-1652 so it is up to the project man...

0 votes

Hello Elliot, Thanks for your query, we will follow up with you over email to resolve this issue. Warmly, Andrew Pierce Product Support Engineer - Redgate / comments

Hello Elliot, Thanks for your query, we will follow up with you over email to resolve this issue. Warmly, Andrew Pierce Product Support Engineer - Redgate

0 votes

How can we help you today?

Andrew P

Comments