Adventure Works for SQL Server

 Adventure Works for SQL Server 2012
http://msftdbprodsamples.codeplex.com/releases/view/55330

 Adventure Works 2014 Sample Databases
http://msftdbprodsamples.codeplex.com/releases/view/125550

Another versions:
https://blogs.msdn.microsoft.com/samlester/2012/08/23/finding-the-correct-version-of-the-adventureworks-sql-server-sample-database/

SQL Server Performance tuning. Table variables vs temporary tables.

https://blogs.msdn.microsoft.com/naga/2015/05/10/sql-server-performance-tuning-table-variable-vs-temporary-tables/

Integration Services: Performance Tuning Techniques

https://technet.microsoft.com/en-us/library/cc966529.aspx

SSIS: Dynamically setting the Default Buffer Max Rows property

https://intelligentsql.wordpress.com/2015/01/06/ssis-dynamically-setting-the-default-buffer-max-rows-property/