Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SreenivasBora
Posting Yak Master
164 Posts |
 Posted - 2005-12-12 : 15:30:46
|
| Hi All,Let us assume database recovery model is FULL/BULK LOgged.Select * into VS Insert intowhich operation is fast? Can any body explain? ThanksSR |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-12-12 : 15:58:36
|
| SELECT INTO will be minimally logged in BULK-Logged recovery,whilst INSERT INTO will be fully logged.rockmoose |
 |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2005-12-12 : 16:29:28
|
| Check out http://msdn2.microsoft.com/en-us/library/ms191244(en-US,SQL.90).aspx for more information |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-13 : 02:13:15
|
| I regard"Select * into"as Poor Form in production code because the target table has to be created on the fly.I prefer to pre-create the table, ensuring that column characteristics are as-expected, and appropriate indexes etc. are in place, AND the column collation is as required.However, that does not consider speed, which is the nub of your questionKristen |
|
|
|
|
|
|
Performance question