Is SELECT ... INTO #temptable the only fast operation in SQL Server?
SELECT ... INTO
No.
Is there a way to make the UPDATE as fast as SELECT INTO?
UPDATE
SELECT INTO