Hello,
I read your project details, I can help you on this. Therefore I need to see query execution plan, can you send it please?
I have more than 20 years of professional experience in SQL Server (since 1996). I have expertise on data analysis, database architecture, design, development, implementation and administration of SQL Server 6.0 to 2019. I have been MCDBA certified since 2000.
I also have extensive experience of writing complex T-SQL queries, stored procedures, triggers, functions, query optimization, performance tuning, detection of possible sql injection points to secure systems, and advising development teams for secure by design development.
I worked with several telco operators, internet service providers, on high volume databases, we implemented new versions, version upgrades, edition upgrades, transactional replications, and always-on projects.
Let's chat to clarify your expectation, structure, and what can I do for you?
Regards, stay safe