• Your DDL script is wrong. You have specified your primary key on a column "index" that doesn't exist in your table definition.
• Why are all your columns except ID...

If you are running certain queries frequently, turn them into stored procedures. Then they will be saved in SQL Server and accessible through the object explorer. And stored procedures...

No. It's no longer available. Microsoft has once again killed a feedback site for SQL Server.

It is often the case that persisting working data can improve performance, and probably won't take long to test this anecdotally, so I wouldn't discourage trying it. But long term...

You can only create indexes on views if they met certain criteria: https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver15

Indexed views are only valuable in limited circumstances. If you've already created indexes on the table that allowed...

What do you mean by "customized" log shipping?

Are you trying to do a timed drill to estimate recovery time, or just trying to prove you can failover successfully?

You ask for...

You can insert the data into a user-defined table type variable , add a table-valued parameter (TVP) to the second procedure referencing that table type, and pass the variable from...

Should your example case statement end in ELSE 3ltrcode END instead of ELSE END? I assume you actually want to join on a3ltr code except for these/similar translations.

Comments is dependent...

a) Putting T-SQL code in a code block

b) Providing data in a consumable format (which can be pasted into SSMS)

This just means (again using code sample control)...

It sounds like you might be looking for Reporting Services data processing extensions, if you're trying to mediate/alter the source data outside of SQL Server or other RDBMS.

The missing index recommendation looks pretty good in this case -- you have a table scan because you are joining on PartLevel, but have no index.

Thank you for providing DDL...

I'd love to see a generic framework/example for this, even if the OP has left the building.

I know your preference for datetime over datetime2, but would also be interested in...

Not automatically. You could view object details right click to generate alter scripts (or create & then replace "CREATE VIEW" with "ALTER VIEW"), and then just do find-and-replace.

Easy if everything...

One would hope response time wouldn't change... though I've seen companies where even that might not be true.

I could see resolution time changing (e.g., help desk declares it resolved, user...

Yes. MS SQL Server uses identity, not auto_increment, which appears to be a mysql construct.

In MSSQL, I tend to prefer using sequence over identity (which now actually uses sequence...