Thanks for the reply. Is this applicable for DTU-based purchasing model as well?

Suppose, if I shrink a database, in order to reduce storage costs, do I need to lower MAXSIZE...

Thanks for the reply.

Thanks for the reply.

How can we perform maintenance like relocation of data files for a database on one of the secondaries without breaking AG and without impacting any other secondary...

Thanks for the reply.

You could develop a custom restore procedure that scripts out existing permissions into a table in database like MSDB and then at the end of restore, trigger a SQL agent...

Is it fine if you check for the 1st character alone. If it is - then, negative value..

LEFT(Name, 1) ='-'

Also, some of the SAN vendors provide storage based replication (ex: NetApp snap mirror etc).. But they may be

costlier.

Database mirroring, log shipping are two options.

Cloud is another option.

https://www.simple-talk.com/sql/backup-and-recovery/high-availability-and-disaster-recovery-for-small-businesses/

SANless clusters is another option

http://us.sios.com/2015/02/dr-journal-cayan-protects-business-critical-applications-sios-sanless-clusters/

Were you able to identify the blocking process?

If you are using Windows authentication, you don't need to manually enter credentials... It will automatically take the login token from Windows layer and present it to SQL Server through...

It seems apart from trace/extended events, there is no way to get the starting time for a specific SQL statement within stored procedure.

Thanks a lot for all the replies.

It seems I picked up a wrong plan for the e-mail attachment. I tried re-creating the issue but surprisingly, it is not reproducible now.

I will get back to you if...

I have sent the stored procedure and SQL query to you in an e-mail.

Thanks.

Please find the query plans attached. Before posting to the forum, I have already gone through your article and spent lot of time but could not find the root cause.

Thanks...

One thing that I don't understand is error got logged only after restarting the web application and then when same UPDATE query was run, it ran fine without waiting on...