The SELECT needs a schema-lock because it has a plan to read the table. The table structure cannot change while the SELECT is reading, hence the lock.

As Johan says, kill...

I'd script out the db, make sure you know the default filegroup and files are set up correctly. Likely this is either something you've missed when checking, or as Johan...

I'm not sure what you want here. There are examples on that page. The top has a TOC with links, like this one for examples: https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16#examples

This was added to...

Please post details of the versions, code if any, and the error log portions. You're assuming we know what "they" or "these errors" are.

For the first part, using AWS instead of some server, I think this makes sense. The idea of FaaS type environments is this particular scenario: you don't want to manage...

I don't have time to test, but I assume this would work fine. The read-only prevents changes to the publisher, but replication reads the log, as a separate job from...

hasn't disappeared. It's here: https://www.microsoft.com/en-us/sql-server/sql-server-2019-resources

The default SQL Server page is always the current version. In the past their web teams haven't gotten good at removing the old version and...

There isn't anyone from Microsoft that will do this. The $199 is for support, but if this is a bug, they will refund the money. That's been their policy because...

As much as I don't like them now, and I'm not sure I'd have enjoyed working on it, I appreciated the simplicity of the iPhone 4/5/6 where they really limited...

A good friend told me years ago to think of a subscription to a quality training service, such as Pluralsight, as an investment in myself rather than a cost.

...

The...

There are always holes. It is very difficult or not impossible to write questions to cover every certainty. Assume this ran and the value was something you checked in the...

No hotfixes are coming for ODBC13. The guidance is to move to 17 or install the GDR update.

If you still are worried, I'd open a support case and dig into...

As Grant noted, hardware, disk or network. You have something slowing down.

I would check the throughput you are getting, the peak reads and writes/s on the disks. Likely somewhere you...

And make a second copy.

Sorry, Rick, that sucks. I did this years ago for a server drive at a company. It was around USD$3k in the 90s.

And now to go...

Like Grant, I don't know. My guess is there is an event of sorts that notes we've gotten to 10%, but with load, the event might delay until 11% is...