This sounds like a good place for monthly partitions.  The monthly switch out takes nearly zero time or resources and then the switched out part can just be dropped...

Well .... first tell me what you would expect.

yes. we see the function. but we do not have sysadmin.

SELECT roles.principal_id AS RolePrincipalID , roles.name AS RolePrincipalName , server_role_members.member_principal_id AS MemberPrincipalID , members.name AS MemberPrincipalName FROM sys.server_role_members AS...

Also keep lock escalation in mind, so you don't lock the full table during these deletes ! (and e.g. prevent inserts being able to be processed )

a while loop handling...

of course, it is obvious the gouvernement has its influence in deepseek !

I've asked it about gouvernement sensitive subjects, to which the western world may be interested in.

It started answering...

now that europe is lagging behind, it is mainly a question of which "partner" you trust most.

Since partnership is being smashed to pieces lately, foundations are shaking, but opportunities are...

Here's a nice overview:

with    ctePartRangesFULL
                  as (
...

Of course, best is to modify the connection strings ( over time )

• Depending on the number of client machines, you could deploy a sqlclient alias to redirect the sqlserver\instance...

My 2ct ( these prerequisites may have evolved over time. U used it a couple of years ago )

1. Did you grant AzureAD/Microsoft Entra to be used with this AzureSQLDB...

check the sql server errorlog file for more information.

( you can find that path in the sql server service startup information )

Replying the above line resulted in

"504 Gateway Time-out

The server didn't respond in time. "

Altough the reply is already registered in SSC.

Except for replying, is there something else we should pay attention to?

For your deadlock graph to be usable, you need to remove:

<event name="xml_deadlock_report" package="sqlserver" timestamp="2025-03-04T15:16:17.973Z">
  <data name="xml_report">
    <value>
Keep the rest
Remove the bottom
  ...

Tools like Solarwinds SQL Sentry PlanExplorer (free) can help you analyse this situation !

It helps you narrow down the 2 tables that are to be addressed to solve the...

your deadlock graph xml is incomplete !