as it seems I manoeuvred myself into a dead end in SQL but definitely need to solve my tasks with the resources that I have at hand...
I use SQL Server Express and I need to process a rather (not very) large table. Due to the fact that SQL Express is limited to a max size of 10GB per filegroup I am not able to run my beautiful scripts.
I already shrinked the database as well as the file but this wasn't enough.
Now I am thinking about splitting the data into two (or more) filegroups but I don't know how to do that and if it is even possible... .
Is there anyone here that knows a workaround?
PS: I can't split the original data due to the nature of the tasks/manipulations