Sorry if i was not clear.This is wat i want to see in my results;

BLOCK STREET CITY NoMatchTotal TOTAL

Luis's script is what...

Thank You

Here is my test results:

if i run from MyDB it executes sp_XYZ that is in MyDB

if i run from master it executes sp_XYZ that is in master

if i run from...

just keep in mind that updating statistics causes queries to recompile.There is a performance tradeoff between improving query plans and the time it takes to recompile queries

...Col1 will have value that application will generate(id)....

It is not some random number.There is some logic involved .

thank you all for your replies

Or RED GATE's Data Compare

I think i should go with EXCEPT

result is int.it is not telling me which column is changed.

CHECKSUM_AGG compares one column at the time.

Thank you very much Jeff.

I'll test your suggestions as well.

rebuild----defrag(space issue)

shink------frag.

rebuild----defrag(space issue)

shink------frag.....

After rebuilding indexes(PRIMARY file group) shrinking fragmenting my indexes(at least i checked 10-15 of them).

rebuild----defrag

shink------frag.

rebuild----defrag

shink------frag......

I have not tried partial shrinking then just do index reorganize(instead of rebuilding).

I'll try and...

Shrinking will fragment indexes

Thank you.

Thank You ALL.