I still like this solution when I need to delete a lot of data,

https://michaeljswart.com/2014/09/take-care-when-scripting-batches/

You can make an Edition Upgrade (see https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades) instead of reinstall. Developer Edition is same like Enterprise Edition and shouldn't be used in a productive environment.

Hi,

you can use also the Balanced Data Distributor, see https://www.microsoft.com/en-us/download/details.aspx?id=4123

regards,

Alex

Thanks for the answers,

I think we must rewrite some statements to avoid the sort warnings. But one last question:

If I use the the hint OPTION (MERGE UNION) in our...

Thanks,

I changed the query to an inner join and for the TOP 25 everything works fine. But with TOP 500 I've got the same problem.

With select * from sys.dm_exec_query_memory_grants I...

Thanks,

I've already activated the option 'optimize for ad hoc workloads'. The growing of the memory for the execution plans is a little bit better, but the counts of the execution...