Does Standard have less RAM available ?

Instance ->> Properties ->> Memory

Or other settings ?

• This reply was modified 4 years, 2 months ago by homebrew01.

LAG function ?

https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15

• This reply was modified 4 years, 2 months ago by homebrew01.

If your database is large, you make want to select "Compression".

Also, a "Clean-Up" task to delete old backups and logs after X days/weeks.

Probably dozens of videos or blogs on strategies,...

• This reply was modified 4 years, 2 months ago by homebrew01.
• This reply was modified 4 years, 2 months ago by homebrew01.

I am not familiar with AG, but at least I can bump your post.

If your database is small, a daily full will run quickly and take few resources. If it's huge, may be better to run a Full less frequently  and take Differentials...

It all depends on the chance that the data or code will be needed later.

If the jobs are no longer needed, you could script them to a file before deleting...

• This reply was modified 4 years, 2 months ago by homebrew01.
• This reply was modified 4 years, 2 months ago by homebrew01.

At my previous job, i set up a process to check for any blocking processes. It would run every minute, and write the information to a table, so I could...

• This reply was modified 4 years, 2 months ago by homebrew01.
• This reply was modified 4 years, 2 months ago by homebrew01.

That will eliminate them from results. The request was to remove the characters 'RECA-' but keep the remaining characters.

• This reply was modified 4 years, 2 months ago by homebrew01.

Maybe the DBA likes calls late at night asking why the application is hung.

If you are running SELECT it is only for display.

UPDATE will change the data in the table.

https://docs.microsoft.com/en-us/sql/t-sql/functions/replace-transact-sql?view=sql-server-ver15

• This reply was modified 4 years, 2 months ago by homebrew01.
• This reply was modified 4 years, 2 months ago by homebrew01.
• This reply was modified 4 years, 2 months ago by homebrew01.

Look at the REPLACE function, and replace with ''  (2 quotes, without space between them)

• This reply was modified 4 years, 2 months ago by homebrew01.

Or, if you cannot add a ModifiedDate column, you could create Insert/Update triggers, and write to an audit table. You'd also need to manage it by deleting old audit data...

In 1 database, I have a user type 'K'

K - ASYMMETRIC_KEY_MAPPED_USER

I don't know much about it. Not sure if I will need to migrate it to a new server project...

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

Thanks for the original script, and everyone's tips & improvements.

Thanks !  I will give them a try.