SQL Server Partition

SQL Server Partition is good for ETL process but not easy to utilize on querying.

• General Resources
  • Loading 1TB in 30 Minutes with SSIS
    https://technet.microsoft.com/en-us/library/dd537533(v=sql.100).aspx
  • Pluralsight Training (beginner level)
    https://app.pluralsight.com/player?course=design-database-structure-sql-server-2014-70-465&author=david-hansen&name=design-database-structure-sql-server-2014-70-465-m5&clip=5&mode=live
  • Brentozar
    https://www.brentozar.com/sql/table-partitioning-resources/
  • $Partition function
    https://msdn.microsoft.com/en-us/library/ms188071.aspx
• Partitioning may slow queries
  • https://www.littlekendra.com/2016/05/03/why-table-partitioning-doesnt-speed-up-query-performance-video/
  • https://www.brentozar.com/archive/2015/09/why-is-this-partitioned-query-slower/
• Using Partitioning to switch tables
  • https://www.littlekendra.com/2017/01/19/why-you-should-switch-in-staging-tables-instead-of-renaming/