Bulk import operations ( BCP, BULK INSERT and INSERT..SELECT )
SELECT INTO operations
TRUNCATE
Starting in Sql server 2008 , INSERT SELECT statement can also be handled with minimal logging.
Partial updates to large value data types, using the .WRITE clause.
CREATE INDEX,ALTER INDEX REBUILD
DROP TABLE
Partition Switch
Merge. (If 610 Trace flag is enabled)