use varbinary

@Grant - purpose is normally to use it as "what has changed since last time I did ETL..." so the last rowversion used is stored elsewhere - and can't...

Hi , i installed winscp on my pc, added it to GAC thru vs (i think a developer script) on my pc as well, and added a reference to...

Ola's index script DOES NOT allow for datacompression as a parameter.

while anyone can change it and allow for that to be supplied as a parameter, this is not desirable, nor...

easy to check - why not try it out instead of asking someone to confirm what you found - or read the code itself.

it depends.

• how frequently is the direct access. tooo many calls is a good pointer to bad application design (depending on application)
• is it doing...

its getting tiresome that you @semolina keep posting same information prior posts already gave, just for the sake of showing off. if you don't have new information to supply refrain...

see this link https://learn.microsoft.com/en-us/sql/relational-databases/tables/manage-retention-of-historical-data-in-system-versioned-temporal-tables?view=sql-server-ver17

scroll down to "Use custom cleanup script approach"

price should not be the reason - there are some free tools to use. and others (like EA from sparkx) isn't that expensive.

hum... I would query the client and see how they are loading the file (to whatever system) and what are the chars they consider NON UTF-8.

or is it that they...

• This reply was modified 1 months, 4 weeks ago by frederico_fonseca.

go read the manuals. your comment shows a lack of understanding of what the openrowset command is so you need to study it

you can backup the db to a UNC share - so if she has permissions to do backups, permissions to share a drive with the SQL Server account then she...

I would say it isn't setup correctly on the NAS.

as you are using a SP - check that the SQL Server account also has required permissions, not just the SQL...

also make sure the encrypted file is being sent in BINARY mode.

you can do it easily. and without substrings or the likes.

note that the pattern you have a "in" does not contain the % sign at the end of the pattern....

let it run - but don't do 100mb chunks. do 50 GB or 100 GB each time.

but it will take a long time to run for sure.