Steven is a Microsoft Certified Solution Expert on Data Platform, MCSA on SQL server 2008/12 and MCITP on BI Developer, Database Developer and DBA.
Steven has worked with SQL server for more than 10 years. He is very passionate about MS SQL server technology and business intelligence and has designed and implemented a number of large scale enterprise BI solutions in a variety of industries.
Steven is an active SQL server community participant. He answers questions at MSDN SQL server forum and speaks at events like TechEd, CodeCamp, SQL User Group etc.
Steven is currently a Senior DBA/BI Specialist at Bank of New Zealand.
Thanks all for attending my session at Auckland MS CodeCamp Summit 2011.
Please see the attached slides and code presented in the session.
Minimal_logging_maneuvering_data.pptx (2.50 mb)
01_Full_vs_Minimal.sql (3.02 kb)
02_Heap_Tablock_On_Off.sql (1.09 kb)
03_Clustered_Tablock_On_Off.sql (1.21 kb)
04_Clustered_trace610.sql (1.46 kb)
Posted in: Data Load | Data warehouse | Transaction Log
Tags: Trace Flag 610, Data warehouse Data Loading, minimal logging, database log