1. One of the ways to tune performance is 'Minimally Logged Operations', the document clearly described about this:
Minimally logged operations are available only if your database is in bulk-logged or simple recovery mode. (so we have to change the recovery model configuration of database to bulk-logged or simple)
2. The second knowledge I have learnt from this document is term 'bulk load', it means many method to load data quickly into SQL Server. They are:
- Integration Services Data Destinations – The method for performing bulk load from the Integration Services ETL tool.
- BCP – The command line utility for performing bulk load.
- BULK INSERT – The method for performing bulk load in Transact-SQL
- INSERT ... SELECT – The method for performing bulk load in process with SQL Server from local queries or any OLE DB source. This method is only ailable as a minimally logged operation in SQL Server 2008.
- SELECT INTO – The method for creating a new table containing the results of a query; utilizes bulk load optimizations.
You can refer the full informationt: http://msdn.microsoft.com/en-us/library/dd425070.aspx
A different document: http://technet.microsoft.com/en-us/library/cc966529.aspx
0 comments:
Post a Comment