Typo from testing. Should be ndf. Corrected.

You haven't provided any DDL here. WE have no idea what the Transaction or Operator tables look like,and your queries don't really provide much explanation. Also, please don't use SELECT...

https://blogs.msdn.microsoft.com/buckwoody/2011/02/01/windows-azure-emulators-on-your-desktop/

https://docs.microsoft.com/en-us/azure/cosmos-db/local-emulator

https://docs.microsoft.com/en-us/azure/storage/common/storage-use-emulator

Probably more out there.

Wait, still the issue after bouncing the server? Could there be some rollback activity taking place?

sp_whoisactive. Sounds like blocking.

I suspect that 2005 just defaults to 2000 as the error when it sees a version it doesn't recognize as that is the most recent version before 2005. You can't...

This isn't well documented for anything other than tables, which is why you may be confused. The Synonym doesn't change context. This provides an easy way to reference something in...

If you still have an on-premise SQL Server, then a linked server to the Azure database can help with your existing job. If you are trying to get rid of...

Good catch. I never run case sensitive, but edited the question.

If you  have 10,000, use sampling. If you know a representative set, use that, otherwise, grab 20-50 dbs, do the backups, and make an educated guess. I assume if you...

Talk to your network sysadmins. Likely BackupExec is running for general file backups as well. There isn't anything wrong with the agent here, but practice restores to a new machine...

I agree with Michael. Don't complicate things. Use a third node.

Use COALESCE()

SELECT
     Id
   , FinalValue = (ISNULL(Val1, '') + ', ' + ISNULL(Val2, '') + ', '
    ...

I completely agree with you, the cloud is where things are heading. Probably not everything. Or if it is everything, it won't be all at once. But its definitely...

There are three important things to think about when considering moving to the cloud.

1. In the UK, and I assume in other countries, you can write the depreciating cost...