Hi WebTechie,

I suggest to use DBATools, a very handy Powershell tool - you can import the modules in your management server and run the require commands.

You can use the...

I'm having a similar issue in my environment too. Just wondering are you using the Ola scripts to run the checkdb? are you using data_purity or physical_only option?
Might...

I was trying not to format the output as I wanted to compare the two tables. Its strange Im getting different results from the same sqlcmd on 2008 R2 and...

I could do that but then I would have to create a new format file for every new table I compare.

The BCP command only lets me export data one table...

Apologies for the poor question structure. Its obviously my first time posting. Please find attached the table, indexes definitions and the estimated query plan.

T1.TEMPLATE_FLG != 'Y' AND T1.TEMPLATE_FLG !=...