The setup we have is as follows:-

Vendor server - server A - SQL2012 Enterprise edition

Reporting server - server B - SQL2016 Enterprise edition

Test server - server C - SQL2016...

I am curious - what fine tuning is required?  Are you looking to limit the results in some way?

Instead of looking at sp_statement_completed and sql_statement_completed you should look at rpc_completed and sql_batch_completed.  The events you are currently looking at identify each statement in a stored procedure (sp_statement_completed) or...

If you are going to rebuild the server - then you should remove all databases from the AG to that server until it has been rebuilt - and also remove...

I don't recall that ever being available in SSMS - but it may have been and just something I never utilized.  With that said - check out https://dbatools.io/ - they...

There are ways to add code to an Access database that call out to .NET code - which is why I would start there...if you can instantiate the report viewer...

This is a SQL Server forum and you have posted Oracle code...are you looking to convert that Oracle code to T-SQL?  If so, then something like this:

Declare...

I would start here:

https://docs.microsoft.com/en-us/sql/reporting-services/application-integration/using-the-webforms-reportviewer-control?view=sql-server-ver15

I would look at other areas to improve performance - I am able to backup a 2TB+ database in less than an hour using the native backup and compressed setting. ...

This is an absolute guess - since you have not provided any sample data to work with...

 Select Top 1 With Ties 
    ...

I built out a PolyServe cluster at a former site and really liked the solution, especially the storage solution.  When we licensed the servers for that environment we licensed it...

You might want to consider this company: https://dh2i.com/

As for SSRS - you want to use Enterprise Edition and licensed across all nodes and use the scale-out functionality.  You would have...

There are some trace flags that if enabled may improve the performance of the integrity checks on earlier editions.  I know that as of SQL Server 2016 those trace flags...

I would create a script in Powershell for the users - there are ways to prompt the users with a 'window' to get parameters but it is quite involved in...

Hi Jeffrey,

we are working in insurance domain and we need to save data in xml file in ftp server , it is a business requirement.

and Yes 1Lakh records =...