The framing is the size of the window. The default is range. This is separate from the partitioning, which you can choose. Without an ORDER BY and without a framing,...

I tend to agree, though I think at times it's not bad.

It is, however, not sustainable for a healthy lifestyle and highly productive work for the vast majority of people.

That last sentence is often the key. The "don't realize this" is the issue.

The architect of SQL Server overall would say what Jeffrey said. The rows are all inserted at...

This is one of those tough design decisions. I might say that until the transaction completes, the row isn't inserted. It shouldn't be visible, though I know you can get...

Always Encrypted is different than TDE. If you are using ALways Encrypted, the keys are in sys.column_encryption_keys and sys.column_master_keys.

• https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-column-encryption-keys-transact-sql?view=sql-server-ver15
• https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-column-master-keys-transact-sql?view=sql-server-ver15

There is a default range regardless of the order by. However, an ORDER BY is required to have rows/range applied.

I've amended the question to note there is an ORDER BY.

bperry's comment made me smile. My son, a few years ago, had an issue with his laptop. We had to go into the cli to restore things and I was...

I'll add that while I thought R would be way better, a lot of the same modules and packages from R have been ported to Python, so I find the...

Not an error. A warning. This still works:

> i <- c(1,2,3)
> j <- c(4,5)
> k <- i * j
Warning message:
In i * j : longer object length...

Thanks, good catch. You are correct.

this is fixed.

I'd think your "AND" is a problem here, as an event doesn't have all 3.

I'm not entirely sure what you want to do here. You can do this in SQL Server (https://www.sqlservercentral.com/articles/geocode-addresses-in-t-sql), directly by using the spatial types. Or you could call the...

Can you connect to the container instance in SSMS/ADS?

Can you post the C++ code and actual error? Not sure I can help here, but a few things I found:

good advice, Eric. Certainly we've seen MS, Google, etc. make changes.  I dislike some of these companies making a far reaching decision quickly without really knowing the effects.

At Redgate, we've...

Glad you found a solution.