My general approach to this type of problem is:

1. Prepare a stage table - which is a copy of the final table with minimal (or no) indexes.  This step truncates...

The issue is only happening to Large tables with over few mil records.

I'm thinking to use PERSIST_SAMPLE_PERCENT or a separate job with fullscan for the tables in question for...

Yes, new file will be in the same filegroup. Driver is that, how I now one big file is not good for best practices. Our database grows and this...

Something like this?

@[User::Path] + "\\" + (@[User::IsActive] == "0" ? "Test1_" : "Test2_") + (DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2)+ RIGHT("0"...

I don't use this tool - so I cannot say whether or not it is using a sampling rate to update statistics.  If the index is rebuilt - statistics will...

This doesn't appear to be a problem with the utility - rather, the problem appears to be auto-updated statistics.  When you see the rows_sampled column as a small percentage of...

If your report parameter is not defined as a date - it should be...if you are calling a stored procedure and the input parameter is not defined as a date/datetime/datetime2...

You can download and install developer edition.

To change where items are deployed - you change the project properties (Project | {project name} Properties).  This is where you define the server...

There is no reason you need to store 'shared' datasources and datasets in the default folder.  You can create any folder structure you need to support your organization.

For deployment purposes...

I have seen this quite often - especially in the health care industry.  A small department level application that does everything the users want it to do - and has...

is it a heap? (does it have a clustered index)

if you process things nightly and delete data then the space can remain allocated but the data content is a...

Ok - so it seems a command such as backup log <database> to disk='nul:' will sort this

it truncates the transaction log, so if I do that just before a...

Is there a reason native SQL Server backups won't work?

Native compression from 2012 and higher has comparable performance to other tools now - and is the reason I no longer...

Hmmm... interesting.  I just found out that a 3rd party database on my system has this problem and the tables are NOT heaps.  Multiple Clustered and Non-Clustered indexes have...

Yes - you can restore to both the primary and the secondary in an AG.  I would recommend trying it out - you have the new system available so you...