script to compare one field value in two xml files.

May be I will first try comparing one field value, which I know it should be there if the are for same transaction.

Please advise.

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 now.

Please...

Hi Jeffrey,

Right after running IndexOptimise, I'm seeing that the rows_sampled column going back to a small percentage of the total rows.

Any thoughts?

Is there any known bug with SQL 2016 SP2 CU1 with Auto-Update statistics?

Here are the database settings we have:

If we store backups, can we just delete records from source  based on the business condition to improve application performance ?and if they need deleted data we can restore database...

Thanks Sue,

Any more thoughts on this?

Schema Changes History report at the server level shows " Alter Index" that we do daily for index defrag. This is not going to help.

Do I need to look for...

Thanks Jeff,

How did you convert 4 million reads to 31 GB of IO ?

I have noticed this error right of starting the SQL Server Profiler trace. Any one encountered this error with profiler trace?

can we suppress [SQLSTATE 01000] messages writing to log file?