I...

Be safe Ralph, and I hope you come through this ok.

Let's please not debate the spread, the impact on the world, or the response. This was really a piece about us coping as individuals, not becoming more upset. Neither you...

Just delete the folder. The git repo is the folder. If you remove it, it's gone.

I've seen it both ways. You have to have good IO systems for striping, both on the source and target. Otherwise you can have issues. You have to test and...

I am not just empathizing with those sick, but also those that having economic issues. This response is going to devastate many families.

Re: queries. You can jump to your desktop if available and run queries, or run them locally. What you do may depend on networking. Ideally, I'd run them from my...

Make sure if there are no rows that you have some value (not null) in the variables. You could do something like

SET @tableHTML = COALESCE(@tableHTML1, ' ')...

Hmmm, I would lean towards some rights here in some way. Maybe try moving the cert backup to a local drive. Ensure you're sa/dbo here as well. Try a different...

There is no guarantee of ordering when selecting from a table without an ORDER BY

You are welcome and good luck.

Take notes, and we'd love to see an article if you get this working. Would help others.

Top are GF cookies, and they break apart quickly.

Were you able to create this certificate in master or on any instance? I've had some issues with certificates in SQL Server as it doesn't seem to support every format...

I'm with Jeff. sp_lock or sys.dm_tran_locks should tell you if anyone has a lock on the table, meaning they're using it.

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql?view=sql-server-ver15

Frederico and Mike have things to think about. This is almost always IO driven, so the more IO you can throw at it, the better. Even if you restore the...