Ok i found a huge reason for my performance issues and i wonder how the best practice is?
Situation is the following:
-  theres  huge amount of  columns in...

I guess i failed to myself properly, unless its still the same issue.
Im not talking about searching for material _Id IN the excel file itself, but in the filter...

hmmmm,

i need to backup and restore the  DTB from the system to another server for developing
but the dev sys has a slightly (2 compared to 2,8)...

Update on the situation:
- there was  barely any growth before the incident
- Its the only  database on the disk
- in the meantime the the .mdf size has...

As i expected and saw in the report already, its alot empty space and the unused space is immense:

So my questions are still existing:

Ive been testrunning the view few times and found him stopping at this point.
With this part included the is stuck data in the live statistics.
But how can a...

Not on a regular basis, i had to recreate it for different testing reasons. There was an update on the data done my my precedessor and after months they realised...

Not sure if you just wanted the results itself or a execution plan again so i attach both.
-->  SQL Server 2016  Express

For me more important...

I have attached the full create statement for the table, the execution plan and the results of sp_help on the table in an Excel File.
There are no FKs...

yeah i have basic knowledge from star and snowflake shemes, atleast what ive been studying and read in books
currently I'm trying to comprehend the full data flow of examples