It is reducing the execution time but in the execution plan the new index is not showing anywhere. How can we say the index is using or not while it...

I can see continously

A time-out occurred while waiting for buffer latch -- type 3 in the subscriber server before restart

How to find out that?

When I check on publication ppt, security it is showing use sql sever agent account.

Is the same thing do we need to look or different...

I want to know is there some details from your experience.

SA account is enabled in both servers. I disabled the sa account in both publisher (Distributor) and Subscriber around 2...

It is online but just restarted the sql server. I started the reinitializing the subscriptions using the snapshot but how to find how much time it will take to complete...

Thank you.

Incase, if I use the correct table name TableB (If I didn't use any Xact_abort on and there are no syntax errors)

In case of any error occur, Is it...

Hi,

I write the transaction below. I use Table B instead of TableB (i.e. table name wrong). It is updating TableA and then saying invalid objectname Table B. When I exectured...

Thank you.

I have a question

when I run the below query why for some of the statisticname have "both auto_created or user_created is zero" and with date just 2 days ago...

I write the sp below and tested. When I tested it is not coming out of loop after the deletion of the records from the Error table.

Is it performance wise...

Thank you.

I will try that.

Thank you all

My environment is small. Required only one database maintenance around 200 GB database.For me that scripts looks so many parameters. I am feeling I might not need the core requirement...

Yes. You are right in line 1187 it is executing.

I will try to modify that sp without calling that.

Thanks for posting this

When I tried to download Hallengren IndexOptimize.sql, it is showing that commandexecute.sql also required but I didn't feel that it is required.

When I am creating the SP IndexOptimize without CommandExecute...

Thank you.

When I run put this query in the job, it is showing error near 'limitied' because of the single quotes. I removed the single quotes for all aliases and...