Thanks Sue, I never considered the CE, so I will have a look at that.  I have used Actual Execution Plan for the query on SQL 2016 Azure and most...

Normally I don't like answering "It Depends" however this is one of those times.  😀

How much disk space do you have?  Remember file growths will tank performance...

No, I have not set that.

qh

In the past when I have been involved in client migrations from 2000/2005 to SQL 2008R2 (I've been around for a while!) and SQL 2008 R2 to SQL 2012/14/16/17 MS used...

HI, just a question, your maintenance plans no longer work, as a small experiment have you tried installing Ola Hallengren's backup scripts and see if they work? (They run...

Great article, this can be a complex area of SQL Server with nasty consequences if you get it wrong.

qh

Great article, best to try this for the first time in Dev or a sandpit VM when you are calm and can think clearly, not at 2am when everything is...

Sorry to hijack the thread, but in a File Share witness, what permissions are required in the file share and who too?

https://www.sqlservercentral.com/Forums/1971491/SQL-2017-FCI-with-File-Share-Witness-permissions

qh

Thanks for the comments, all very valid.  I read that Facebook *expected* CA to use their data correctly and to remove it once they had finished with it, not to...

SQL 2016, I think it is just a fantastic product (I don't say that easily about SQL versions).

Find it odd that I've worked with versions from 2000 right...

When it works, replication is great and free out of the box (do you have to pay extra for this in Oracle?), it still has it's uses.

When it...

Thank you Steve, that is a great idea.  However the business is *very* reluctant in touching the existing live system (unfortunately it is running as prod with IIS and SQL...

Great work Ola, thank you.

qh

Looking at what you desire to achieve have you considered Merge replication?

https://docs.microsoft.com/en-us/sql/relational-databases/replication/merge/merge-replication

https://technet.microsoft.com/en-us/library/ms151329(v=sql.105).aspx

qh

Thanks for heads up Jeff. I am using SAS token, (see my first post) where my backup script works, so I am using block blobs and not page.
In theory...