At a minimum, an EC2 instance will have an EBS volume for the operating system. You can add additional volumes.

What's the nature of the data on the EBS volume(s)? When...

Is this related to my response to https://www.sqlservercentral.com/forums/topic/slow-execution-when-update-chemical-id-on-table-chemicalhash-so-how-to-enhance-i suggesting using a hash for comparisons & indexing?

Hashbytes returns a varbinary(64) for that algorithm --  a very nice, efficient type for...

Please provide DDL (table definitions) & sample data as insert scripts as described in How to post code problems.

It's absolutely possible in cloud services. In addition to more conventional virtual servers and containers, I believe all offer "serverless" services (e.g., AWS Lambda) that provide on-demand resources for the...

Very closely related to https://www.sqlservercentral.com/forums/topic/slow-execution-when-update-chemical-id-on-table-chemicalhash-so-how-to-enhance-i#post-4034307.

As with that one, review your data types.

Why is almost every column [nvarchar](3500)? It looks like some tool auto-generated types, and nobody corrected them. Is every...

I'd start by reviewing data types -- Do you really have unicode data that requires nvarchar? And do you really need max size (not inherently bad if strings really are...

How many scenarios/rules are we talking about? Based on what you clarified, you may well have a case for a rules table/engine approach.

If many rules, if the rules change, and/or...

I'm not clear what you mean by rules-based updates. When you say "apply business rules to update my table", do you not also mean for inserts into that table? Based...

The error message, somewhat misleadingly, describes the problem -- you need to specify the columns in the insert statement if not inserting all columns corresponding to every column in the...

That's OK, but it's best to be clear about that so that volunteers know not to recommend platform-specific (TSQL) solutions.

Here's a tek-tips Pervasive forum: https://www.tek-tips.com/threadminder.cfm?pid=318

A calendar table is great for that.

But if you want to derive it dynamically, and you're always executing on the day following the end of the date range:

            
May 11, 2022 at 9:06 pm
            
#4031425

            
            
                                                
        

PSQL? Are you using postgres? You posted in a SQL Server 2019 forum.

Joe Celko's Trees and Hierarchies in SQL for Smarties -- Treason hierarchies is a whole different topic 🙂

Auto-correct did a number on your post, Joe.

If you're not seeing it via direct group membership, look at nested groups (user is a member of a group that is a member of another group that has database...

Do any Windows domain groups have SQL Server Windows logins/database access?