Home Forums SQL Server 2012 SQL 2012 - General Two tables, exact same structure but with different names, behave differently while performing mass updates. RE: Two tables, exact same structure but with different names, behave differently while performing mass updates.

  • December 27, 2017 at 7:17 am

    #1973575

    Lynn Pettis - Tuesday, December 26, 2017 2:03 PM

    The only time I have seen two identical tables behave differently came down to the fact the data was not stored identical between the two tables.  The data distribution was different even though the data was the same.

    Would you mind explaining why should that make any difference? 

    To answer your question, no it's not stored any differently. Both of the tables have the data stored ordered by the bigint PK. The rows are ordered and match between the two tables based on the identity column.