I have a view with about 5 million records in it.
I need to transfer all of these records into a table, what is the fastest way to do this? The way I initially tried to do it (and it takes forever) is:
INSERT INTO TABLE
SELECT * FROM VIEW
I'm running this query in my VB.NET program, not SQL Mgmt Studio.