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
Last activity: Dec 21, 2023, 02:12 AM