as I said you need to add a join to the sales.salesorderheader table - that is what you are missing. putting "sales.SalesOrderDetail.SalesOrderID  = sales.salesorderheader.salesorderID" is not joining - it is...

Few errors

Referencing a table on the select columns that is not part of the joins - that is your main error

Giving alias to some tables, and then using the full...

And depending on the needs RedGate SQL Monitor may also be an option - limited to SQL Server only (and some details of the underlying server) but with good info...

yes that is a reasonable assumption if the 2 tables are on the same database

from https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-2017

Each database has a counter that is incremented for each insert or update operation that...

As it is a HEAP it may not release the space - but doing a table rebuild will deal with the issue

remove the convert on the where clause - for display purposes you only need to change the select list.

and this really should be done on the visualization layer not on...

Sorry if my previous reply sounded a bit harsh.

Had a chance to review your replies and now I think the following will do what you need.

two options - both should...

Found another document - this is a bit more clear on the whole embedded subject.

https://www.arrow.com/arrow-services/msembedded/wp-content/uploads/sites/3/2019/07/windows-embedded-server-decision-tree.pdf

Main difference from "standard" licenses is a longer support period - possibly as Steve mentioned using...

that code you just posted, asking the "experts" if it is a good option is what I gave you on the first reply to you.

yes it is one of the...

But do take in consideration that the example that Lowel gave you requires Microsoft Office to be installed on the pc/server where it is executed - if on a server...

get used to post full ddl and sample data - hard to give correct help without it.

2 possible ways to do it (more exist) - which one is better depends...

I wouldn't call 160 massive and this works for us.

Once all the files have loaded, we then archive the files (just in case) into a zip file and then...

this may help http://download.microsoft.com/download/F/C/C/FCC534B7-90B3-464D-8A24-006DF155F769/Windows%20Embedded%20Server%20and%20Microsoft%20SQL%20Server%20data%20sheet.pdf - your best bet is to contact one of the embedded reselers and ask them about it.

you need to rebuild the index. https://www.sqlservercentral.com/steps/stairway-to-columnstore-indexes-level-8-optimizing-clustered-columnstore-indexes

look at Ola scripts https://ola.hallengren.com/ - will do what you asked (and a lot more if you need)