based on your update you can still do multiples in one go - we don't have enough detail on how you get those formulas and how much they differ, neither...

can't you group /pre process updates so you have a lower number of transactions but each updating a higher number of records in a way that the records updated by...

you need to make sure you have SQL Server Integration Services installed for it to work.

LEFT JOIN pag5_users US2

ON TR.id_res_puser = US2.id

give it another alias

dup post

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

can you also provide the output of

DBCC loginfo ('TEEST')

or

sys.dm_db_log_info ( database_id )

replace database_id with database_id value from sys.databases

if it returns more than 300 rows just state how many

on those db's that case issues I would start by looking to see how many VLF's they have. and if too many get the source (production DB) fixed in the...

and.... how many VLFs - higher number does delay restore.

and... if restoring from a lower SQL version system objects will also be upgraded - this adds to restore time.

if you bother to look at the results of the index definition you will discover why its null.

and get used to use alias on the tables - makes your life...

if you do your clustered index as you...

you really need to read the manuals for MySQL - datediff in Mysql is totally different of that for SQL Server hence the error you get.

in mysql you would need...

all the SP's on...

Cyberark if used...

there is documentation for it - https://docs.cyberark.com/Product-Doc/OnlineHelp/AAM-CP/Latest/en/Content/CP%20and%20ASCP/Net-Application-Password-SDK.htm?tocpath=Developer%7CCredential%20Provider%7CApplication%20Password%20SDK%7C.NET%20Application%20Password%20SDK%7C_____0

as in powershell you can use any .net dll's its just a question of setting up a script to do it.

I may be able...

Hello @bobrooney.81 the solution to your problem is quite easy: Start thinking by your self. Then switch to https://ola.hallengren.com. There you find every necessary information about your problem.

But hey:...