Do/can your last names include any hyphenated names? Do you have any cases where you also have middle names (or two part last names with spaces)?

If not, CHARINDEX & SUBSTRING...

You indicated you split a table into two tables, but showed the DDL for only one table. Is this the before or after?  If after, what's the second table?

What are...

Every CPU these days is multi-core. Obviously, faster clock speeds is generally better than slower for similar core counts.  Look at https://www.cpubenchmark.net/ for CPU ratings & comparisons, including performance/price ratios.

Glen...

What should room_type be if it's a tie (50/50)?

What do you mean by "re-allocate the files"? Changing the name?

You haven't shown the other pages. Did you change the Database name on the first (General) page? That is what...

Yes it's possible. You can see if this thread helps.

For the purposes of the .Net tutorial, it seems like authentication type should be irrelevant.

I agree w/ Mr. Gale that using prefix "vw" for views and "trg" for triggers is a good, common, reasonable exception to the "don't prefix w/ object type" rule. And...

In general:

• Be consistent. A mediocre naming convention applied consistently is more user-friendly and less error-prone than a great convention applied only sporadically.
• Don't obsess -- don't spend too much...

It seems to model the real world. The additional complexity appears to be necessary.

You hit on one of the big shortcomings of the old approach -- a single user type...

By putting

 AND w4.MDMOVT = 'SKR'

into the WHERE clause, you effectively turned the LEFT JOIN into an inner join. Move it to the LEFT JOIN - i.e.,

            
October 5, 2021 at 9:05 pm
            
#3936846

            
            
                                                
        

That might give clues, but when people ask you to post execution plans, what they really want is to post the xml -- i.e., right click on the execution...

I don't know about prove, but ORMs often have a telltale signature.

I can easily recognize Entity Framework queries, which  alias tables as ExtentN, and alias parameters as @p__linq__N.  e.g.,

            
September 30, 2021 at 2:09 pm
            
#3935068

            
            
                                                
        

https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally

A quick search for IBM DB2 equivalent of SQL Server STRING_AGG leads to the LISTAGG function in DB2.

I'm glad that video better clarified what I tried to demonstrate in my example, and that you now have a working solution.