Hi ScottPletcher,

Thanks for the code. It is really helpful. I can see if the database does not have any backup after it is created is not showing. Anyway I...

Hi ScottPletcher,

Can I add one more condition if the full backup is not happen in last 7 days, show me the database names.

Got it

FROM cte t

WHERE t.rn = 1

and backup_finish_date...

• This reply was modified 1 year ago by  Saran.

Hi ScottPletcher,

Thanks for the code. It is really helpful. I can see if the database does not have any backup after it is created is not showing. Anyway I will...

Thanks. I will take look on that link.

Forgot to ask . Does the SSRS use memory from SQL max memory or it's also from outside.

Thanks for the update. I have 65GB on server with two SQL instances.

Shall I configure 15 GB to SQL1, 15GB to SQL2, 15 GB to SSAS Tabular & Rest of...

Thank you Jonathan AC Roberts.

It is working amazing.

I just need first line or row from the table. That I am going to copy and put it in insert statement to insert to table.

Sorry, missed the comma.

Result should be - 1 ,'A','US'

insert into #tbl_Test values (1 ,'A','US')

• This reply was modified 1 year, 1 month ago by  Saran.

Thanks both and it is working good.

Thanks Drew for the script and insert statement.

Thanks for the update Jeffrey. We will consider that as well.

Hi,

Thanks both for your response. It helps me a lot. We have test server built for testing everything for 4 weeks by running SSIS job etc.

I have tested database restore...

Thanks for the update. It helps us.

I will ask developer to fix that as well.

Most of them are old join syntax Table1, Table2.

• This reply was modified 1 year, 2 months ago by  Saran.

Thanks both of you. I will check the AG setting etc.

Thanks Jeffrey Williams for detailed answer, I have new learning.

Thank you.

Thanks, it is little complicated to configure https://spaghettidba.com/2022/02/28/recipe-5-killing-blocking-spids/