Database Performance Issue with UPDATE on SSMS

Craig Sorochuk 1 Reputation point
2021-02-26T12:35:46.42+00:00

I am executing the simplest of UPDATE queries UPDATE pitch_data SET TEAM_HOME = HOME_TEAM; using SSMS/Azure, and on a dataset of only 123,000 rows, it is taking 3 minutes to complete. The same query on a local, slower, 2-y old laptop is executing in 30 seconds using MySQL. Any suggestions on possible performance reasons for this would be appreciated.

Azure SQL Database
{count} votes