>>Now, let’s imagine that my procedure is not finished but, at the same time, the SQL Server engine executes the procedure stored C on the same session.

If you are running...

• This reply was modified 2 years, 11 months ago by Ken McKelvey.

Maybe:

SELECT *
FROM YourTable
WHERE ExtractDate >= CONVERT(char(6), DATEADD(month, -6, CAST(YEAR(CURRENT_TIMESTAMP) AS char(4))), 112)
    AND ExtractDate < CONVERT(char(6), DATEADD(month, 6, CAST(YEAR(CURRENT_TIMESTAMP) AS char(4))), 112)

That could produce race conditions and deadlocks. The following is...

• This reply was modified 2 years, 12 months ago by Ken McKelvey.
• This reply was modified 2 years, 12 months ago by Ken McKelvey.
• This reply was modified 2 years, 12 months ago by Ken McKelvey.

As ownership chaining only  works within a database, with a view you will either have to create domain\MyServiceAccount as a user in the Finance database with SELECT permission on the...

This is just the estimated plan.

SET STATISTICS PROFILE ON gives the actual plan. SET STATISTICS XML ON gives the XML although I just generally right click on...

You say the plans at 120 and 150 are identical but have you verified this by saving both Actual (not...

• This reply was modified 3 years ago by Ken McKelvey.
• This reply was modified 3 years ago by Ken McKelvey.
• This reply was modified 3 years ago by Ken McKelvey.

Row Level Security would usually be based on AD groups or Roles.

While your problem description is vague I suspect Row Level Security is not the best option here due to...

• This reply was modified 3 years ago by Ken McKelvey.
• This reply was modified 3 years ago by Ken McKelvey.

https://learn.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver16

Float is an inexact data type so should probably not be used if you want accuracy.

Microsoft changed the inplementation of float in SQL2016. See Converting float and real data in...

DECLARE @sumdocument int;

WITH Bollore
AS
(
SELECT SEQ_DOC
FROM OPENQUERY([pprod.link.db.bollore-logistics.com], 'SELECT SEQ_DOC FROM LINK.dbo.DOCUMENT')
)
, Bad
AS
(
SELECT SEQ_DOC
FROM OPENQUERY([pprod.link.db.bad-logistics.com], 'SELECT SEQ_DOC FROM LINK.dbo.DOCUMENT')
)
, AllDocs
AS
(
SELECT SEQ_DOC
FROM Bollore D
WHERE EXISTS
(
SELECT 1
FROM Link.dbo.EVT_ATT L
WHERE L.SEQ_DOC =...

max(vid) AS vid, nid

-- Your
CREATE TABLE dbo.PermTable
( Value VARCHAR(100) ) COLLATE DATABASE_DEFAULT

-- Should be
CREATE TABLE dbo.PermTable
( Value VARCHAR(100) COLLATE DATABASE_DEFAULT );

-- or just
CREATE TABLE dbo.PermTable
( Value VARCHAR(100));

I have never done it but I think prior to SQL2022 query store only worked on the primary replica.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16#query-store-for-secondary-replicas

As a matter of interest, what values are returned by the following queries:

--1
SELECT CAST([value] AS int)/1024
FROM sys.configurations
WHERE [name] = 'max server memory (MB)'
ORDER BY [name]
OPTION (RECOMPILE);

--2
SELECT CAST(ROUND(total_physical_memory_kb/1048576.0,...

To be honest, Auto statistics don't work well with indexes with ever-increasing keys. And, even after the improvements they made, I still think that they fall a bit short. Go...