Sample Header Ad - 728x90

insert on table being unnaturally slow

0 votes
2 answers
3889 views
I have an "Basic" pricing tier Azure SQL database with a table of 7 columns, an ID column of int that is the clustered index and primary key, one datetime2(0) column, 3 varchar(100) columns and 2 varchar(MAX) columns, all nullable. The table has no triggers, constraints or foreign keys. Now I'm inserting a large amount of test data, I'm doing an INSERT INTO table_name () values ()` GO 680000 However the query has been running for 5 hours and only 290000 rows have been inserted. I'm trying to find out why.
Asked by Tessaract (167 rep)
Aug 16, 2021, 04:45 PM
Last activity: Dec 21, 2023, 02:12 AM