We manage SQL Server data in a growing environment where our One of the most popular archiving techniques with data that includes date and can be scaled early...

I already gave you a alternative solution - up to you to decide which route you wish to take.

it is very likely - look at https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/system-tables-sqlserver.htm

looks like this bit "The adds table (a_<registration_id>) maintains information about each inserted or updated record (feature) in a versioned business table and...

I assume you aren't going to be running this on a server - " New-Object -ComObject Excel.Application }" - this requires Excel to be installed on the server which is...

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

it has more than 4 properties - but unless you specify -properties * or -properties comma_delimited_list_of_properties it won't "show" them to you.

even for on prem AD I would advise you...

any current SQL Server should be 64 bit, specially if it has SSIS catalog on it - so install that one, and ensure that when you execute the package you...

thats the latest version of the driver  - you can download it from here https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15

make sure the powershell version is setting the "Binary" mode for transfer - if not and if the default is not binary it will mess it up.

double apologies - way to many here that just expect us to supply them with the links - and I misread your title and didn't confirm the contents.

Unless Paul sees...

looks like you need to learn to google. first hit when searching for it https://www.sqlskills.com/help/waits/sleep_bpool_flush/

linked server will always have that issue - what you need to do is to alleviate the problem.

when pulling data from Oracle to SQL one of the biggest issues is...

I assumed your company owned the code - should be easy to change it - and if not you can...

change the ID to be sequential - that will alleviate that issue.

both potentially - depending on your data that distinct may be processing results with thousands of duplicated values which require a sort to get the distinct.

exists will only see if...

possible way - but without a real execution plan of this with one of the "bad performance" queries we don't know if it is the best option

replace...