You could try the maxdop hint to avoid parallellism

I really should have a sticky on Jeff Moden's post about the (non)-sense of generic rebuilding / reorganizing indexes.

A lot of resources are consumed during the reindex with little or...

If you are having troubles with SSL, check URLRoot in reportserver.config. Like when using powerbi reporting server.

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/rsreportserver-config-configuration-file?view=sql-server-ver16#bkmk_URLReservations

<UrlRoot></UrlRoot>

By default it starts in  Report Server url: https://server/ReportServer

Troublesome with SSL wildcard *.domain.com.

<UrlRoot>https://server.domain.com/Reportserver</UrlRoot&gt;

Start...

Can you elaborate why the partitioning is requested. Because of sideloading data without blocking?

SQL Server uses statistics in order to choose what approach is best. Usually an appropriate index achieves...

from https://learn.microsoft.com/en-us/answers/questions/1045928/best-practice-to-decide-partition-table-in-sql-ser

It completely depends on how you use the tables.

There are 2 main benefits of partitioning:

Partition elimination on queries

Partition swapin/out for data loading/purging

For partition elimination, the partition must be included...

Not really a clue why it would be slower

Patchlevels of the SSIS box? Power saving options?

Are you using the right url?

• Web Service Url: plaintext meant for services

  • https://server/ReportServer

• Web Portal url: fancy meant for end-users

  • https://server/Reports

I prefer giving access to views, for the reasons you give in 1 & 2.

View definition only needs to change when it is no longer compatible with its tables

Where did you get the blocking chain information from?

Could it be that a program started a select but doesn't retrieve all rows?

SSMS is so slow to start. Query analyzer was better.

I like the way of having thin clients with plugins. Of course it takes a while before most of the features...

You could start with the Azure SQL basic tier and scale up / down when required.

Link  https://learn.microsoft.com/en-us/sql/relational-databases/databases/move-database-files?view=sql-server-ver16

Thanks for your response Martin.  We will stay with VS2019 then.

It is indeed for SSIS & Excel.

32-bit: Design Visual Studio 2019. VS 2019 due Ms Oracle Dataconnector and BimlVarigence plugin

64-bit: Run with SSIS on SQL Server / easier datatyping

Thanks frederico_fonseca...

Grmbl, the /quiet installationswitch workaround for installing Access Ace drivers 32 and 64-bit side-by-side seems to have stopped working.