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

It's getting popular to rename brands

• Twitter to X
• Azure AD to Entra https://techcommunity.microsoft.com/t5/microsoft-entra-azure-ad-blog/azure-ad-is-becoming-microsoft-entra-id/ba-p/2520436

I agree with Grant. Thought that datacollector was obsolete.

A monitoring tool or DIY .

For DIY you may experiment with dbatools powershell module.

Thanks for the suggestions, but the dataset was too small. An expanded version generates too much nulls.

Got a sufficient solution working posted below.

Better dataset:

DROP TABLE IF EXISTS...

Thanks Drew, Jeff for highlighting the alternative with DENSE_RANK. Interesting way to handle or exists

*edit *

• This reply was modified 2 years, 12 months ago by Jo Pattyn. Reason: Possbile wrong answer