Some tables have multiple unique 'keys'.   One should normally map to a 'primary key' constraint.  Any other keys should map to 'unique' constraints.   Subtle differences are 'primary key' constraints can...

Hello dqurve

Was also a bit confused by the cursory code sample... Hopefully, this will help.

Be aware it is often good to have a permanent calendar table available in your database. ...

Presumably you are defining the PRIMARY KEYs as such, rather than using UNIQUE constraints?  PRIMARY KEYs 'default' to being clustered.  Broadly speaking clustering improves performance.  These days, for permanent tables,...

Hello hamedavodi

In principle, it is best if all columns fit within one data page.  However, most important is to size columns as small as possible.  For example, where you can,...

It’s been a while since I’ve worked with Access upsizing.  Hope this outline helps.

Do your queries need to return complete tables?  Usually, for best performance, apply joins and WHERE clauses...

• This reply was modified 3 years, 6 months ago by  Bredon.

Hello Stephen

Its tricky coming up with a solution when there is no schema or test data posted with a complex query...

Some observations:

1. JobOperations.jmoOperationQuantity appears twice in the group by clause.

...

Hello RCRock.

Think you can achieve this using OPENROWSET. Be warned that it can be tricky configuring the connection strings.  The Microsoft documentation has a pile of different examples that should...

Hello Dandschul

Sorry, can not reproduce your problem.  SQL used follows.  Error message produced, as expected:

Msg 5074, Level 16, State 1, Line 29
The object 'my_view' is dependent on...

Strange.  Using SQL Server 2019:

Declare @d tinyint
set @d = 1
RAISERROR(' %s is the current value', 1, 0, @d);

Get error message:

The data type of substitution...

Hello dimitrisv

The reference quoted above states that SSIS was not an option.   Is that so in your case?  SSIS is something to try.  In the Import/Export Wizard, choose to save...

Hello Alex

You might get somewhere by examining first result sets using dm views, see  sys.dm_exec_describe_first_result_set_for_object.  Read the documentation carefully though.  There are a pile of limitations including CLR, Dynamic...

Have similarly been learning Python lately.  This is because of an interest in both DevOps and AI.   Python seemed very versatile.  Over the years I have learnt many scripting languages...

No problem 'creating' the view, as the question asks.  However, not sure the view necessarily 'works'.  Potentially, the CASE statement WHEN clause  may fail when converting varchar/nvarchar (returned by SUBSTRING)...