Try creating the view eliminating the views and running directly against the tables

My suggestion is to create a separate database and insert the changes periodically into tables in that database using tables one for each temporal table. I would produce the report...

XML output with xsd file could be used to present data in a table. https://www.w3schools.com/xml/schema_example.asp

Can you identify the query holding the lock so it can be optimized? It won’t be possible to give useful advise without more information. Once the query is isolated I...

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/view-and-read-failover-cluster-instance-diagnostics-log?view=sql-server-ver15

USE test
GO
IF Object_id('STKTraceItemBatchAttribute', 'U') IS NOT NULL
   DROP TABLE STKTraceItemBatchAttribute;
GO
CREATE TABLE STKTraceItemBatchAttribute
   (
     TraceableItemID int
 ...

If I have a table:

CREATE TABLE EMP
   (
     ID int
   , NAME varchar(50)
   , TITLE varchar (20)
...

Are the users authenticated using integrated security or seperate sQL Server accounts or does the Access application connect using one SQL Server login or application group?

How are the users of the access database authenticated in SQL Server?

You need a "table" with the months with the range of months.

drop table if exists sales;
create table sales(DateOfSale date, Price smallmoney);
insert into sales values('20190802', 45),('20191015', 45);
with months...

The best performance would be to create 4 procedures, 1 calling and 3 for each contingency. Each of the 3 would have an execution plan optimized for the workload.

• This reply was modified 5 years, 4 months ago by  Joe Torre.
• This reply was modified 5 years, 4 months ago by  Joe Torre.

Good points ZZartin. To do a more thorough analysis you could persist that data by collecting it into a user table.  Dm_db_index_usage_stats is the a good place to start in...

Try running these commands at the command prompt on the new server:

msdtc -uninstall

msdtc -install

Then restart the SQL Server Service

If you have 0 or low numbers in the columns user_seeks and user_lookups,  and to a lesser extent, user_scans, then the index isn't very helpful. The column user_updates logs the...

Research [sys].[dm_db_index_usage_stats]. It has information on usage.