You can gather statistics using this object sys.dm_db_index_usage_stats

It will provide information about seeks, scans, updates etc.

https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16

SELECT 
    DB_NAME(database_id) AS [Database Name], 
 ...

In detail explained here in this link.

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

@kakovatos7:

where is the output folder located? The domain user which is running the SQL Server Service needs access to that folder. Ask your NS team to provide access...

From the error message, looks like you are trying to INCLUDE certain columns in CLUSTERED INDEX.  Remember, when you create clustered index, all the columns of a table are automatically...

Is this happening when you are trying to connect via listener ? Can you please add the output of select @@servername after connecting thru listener?

Agree with Drew.

Yes, show us what you tried. I give some additional info., understand how GROUP BY works and when to use it.

Can you check if the data movement is in operation and AG is functional between Primary and Secondary nodes?

Have your tried running this agent job earlier?

Would help to see the DDL for the Tables, TVF and the indexes defined with some sample data to reproduce the behavior. If it is not inline then a new...

Try this:

Go to the source connection, check the text file properties... make sure you have selected the checkbox Unicode.

You should also upgrade to SSRS 2016.... on the reporting side to support 2016 database.

-- Open the report and check for SQL is correct in the report.

-- Compare the table...

Link is going back to a topic written in 2012 which is an  entirely different.

You can give these a try:

a) Import Export wizard.

b) Use Excel directly, Connect to the Instance by creating a connection and retrieve the data in itself.

c) Use SSIS.

Note: From the data you provided  program_id from client_vist cannot be joined with client program because they do not match.

May need some code tweaks... to get the correct program_id code,...

Here is another way!!

-- Create a grouping column based on the difference between ID and row number within each usertier
;WITH CTE AS (
  SELECT *, 
...

What are these WT1, WT2...... in the output? Why 15 has to be shown under WT1 for B and not in WT2?

You can use CASE WHEN THEN ELSE END and...