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.

Can't remember an Error 500 with SSMS.

Do you have an obfuscated connectionstring? What kind of authentication are you using? SQL / Windows / ...

Is the server currently waiting on memory?

https://erikdarlingdata.com/signs-you-need-more-memory-in-your-sql-server/

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

As Ken mentioned CX_PAKKET got subdived in CXSYNC_PORT en CXSYNC_CONSUMER . Related to parallellism. Have you set a maxdop?

Catch up with the latest CU 7 for SQL 2022 https://www.microsoft.com/en-us/download/details.aspx?id=105013

Have you...

Whilst installing a new laptop, noted that the download link for sql 2019 developer has disappeared