Shafat Husain (12/25/2014)
No, Simple insert operations does not come under minimally logged operation.Here is a list of all the minimally logged operations.
http://technet.microsoft.com/en-us/library/ms191244(v=sql.105).aspx
Um...
From the very page you linked:
Bulk import operations (bcp, BULK INSERT, and INSERT... SELECT). For more information about when bulk import into a table is minimally logged, see Prerequisites for Minimal Logging in Bulk Import.
Now sure, a single row insert is not going to be minimally logged, but larger insert...select certainly can be, although there are a whole lot of requirements that have to be met first.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability