as per documentation (https://docs.microsoft.com/en-us/dotnet/api/system.data.datarow.itemarray?view=net-5.0) it converts each column of a row onto a  array of objects - and for each row on the recordset being retrieved it adds each column...

you do need to practice more powershell - and try out the combination of commands that you have available to look at the objects returned - main thing is to...

it is on each query as per example on the link I supplied

I think you're correct, you should do this for all tables.  No sense wasting resources scanning a 900-row table either.  Of course that 900 rows could be far larger...

you need to explicitly set the parameters db datatype - see https://stackoverflow.com/questions/19891999/how-do-i-force-sqlcommand-to-not-encode-parameters-as-unicode-nvarchar/19892033 for an example

one initial question - your query has lots of functions - as it is anonymizes we can't see what they are, but can you at least clarify what they are...

as a zip file it works as seen below - you may be able just to rename the .sqlplan to be .sqlplan.zip and upload it

• This reply was modified 4 years, 10 months ago by frederico_fonseca.

estimate will most likely help - not as good as the real thing though.

as for the @variable - never saw that error on Plan Explorer - if you save the...

homework - final big work I would say.

when you are running the query you still not using Plan Explorer - that is all SQL Server on its own.

only once the query runs and SSMS produces the explain...

SQL Sentry will only "reveal" itself on SSMS when you have done a explain plan and have the window with it visible.

at that point right-click on it and  you have...

see this example - with it you should be able to set  your ssis to work with the rowversion value

/*
if object_id('test') is not null
drop table test
create table...

• This reply was modified 4 years, 11 months ago by frederico_fonseca.

with the caveat that if using the latest version of SSMS you loose the Debug capability

you can use SQL Sentry (https://www.sentryone.com/plan-explorer to post a anonymized plan - that will keep your restrictions in place as all names / variable contents are replaced with identical names....

with newer technology it is possible on the SAN side - look for example at Dell XtremeIO - its snapshot technology means you can just click the button and you...

• This reply was modified 4 years, 11 months ago by frederico_fonseca.