SQLServerCentral.com Articles tagged Partitioninghttp://www.sqlservercentral.com/Articles tagged Partitioning posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Tips to Optimize Your SQL Statements - Part 2Read more tips to optimize SQL statements, specifically on a Data warehouse.]]>http://www.sqlservercentral.com/articles/SQL+Server+2014/103681/Thu, 07 May 2015 06:00:00 UThttp://www.sqlservercentral.com/articles/SQL+Server+2014/103681/Implementation of partition switching within SSISIn the third part of a series on loading a partitioned data warehouse efficiently, we see how SSIS can be used to perform the ETL tasks.

"A real time saver" Andy Doyle, Head of IT ServicesAndy and his team saved time by automating backup and restores with SQL Backup Pro. Find out how much time you could save. Download a free trial now.

]]>http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/111143/Tue, 15 Jul 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/111143/Table Partitioning –XE Diagnostic for Data MovementsDiagnose partitioning related data movement between file groups using Extended Events and Debug Symbols]]>http://www.sqlservercentral.com/articles/Partitioning/109486/Thu, 22 May 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/109486/Partitioning Data in a Multi-tenant Data Warehouse SolutionPart two of our series looks at the partitioning strategy to separate customers' data, providing security and performance.]]>http://www.sqlservercentral.com/articles/Data+Warehousing/108958/Tue, 22 Apr 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Data+Warehousing/108958/Automate Sliding Window Partition Maintenance: Part IIIPart 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell]]>http://www.sqlservercentral.com/articles/Partitioning/71657/Fri, 21 Mar 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/71657/Automate Sliding Window Partition Maintenance: Part IIPart 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.]]>http://www.sqlservercentral.com/articles/Partitioning/71656/Fri, 14 Mar 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/71656/Automate Sliding Window Partition Management: Part IA new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.]]>http://www.sqlservercentral.com/articles/Partitioning/71655/Fri, 07 Mar 2014 07:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/71655/SQL Server 2012 Analysis Services Partitioning Performance DemonstrationHow much of an improvement in processing time can a simple SQL Server Analysis Services (SSAS) partitioning structure provide? Can you provide any examples? Does this processing time improvement only apply to the fact tables? Check out this tip to learn more.]]>http://www.sqlservercentral.com/redirect/articles/101265/Mon, 19 Aug 2013 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/101265/Partitioning in SQL Server: Managing Sliding Window ScenarioThe concept of a sliding window scenario is to manage and keep the same number of partitions on a partitioned table over time. Learn how in this step-by-step from Arshad Ali.]]>http://www.sqlservercentral.com/redirect/articles/98157/Thu, 11 Apr 2013 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/98157/Filtered Indexes - Simple Partitioning without Enterprise Edition?This article discusses using Filtered Indexes as a simple partitioning strategy in SQL Server Standard Edition]]>http://www.sqlservercentral.com/articles/Partitioning/96247/Thu, 21 Feb 2013 07:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/96247/Partitioning in SQL Server - Part 3Arshad Ali provides a step-by-step guide to create a partitioned table/index.]]>http://www.sqlservercentral.com/redirect/articles/96603/Tue, 05 Feb 2013 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/96603/Partitioning in SQL ServerPartitioning has improved with each new version of SQL Server. From partitioned views in SQL Server 7.0 through partition table parallelism in SQL Server 2008. With SQL Server 2012, we are now allowed to even create up to a 15K partition on a single table.]]>http://www.sqlservercentral.com/redirect/articles/95740/Thu, 03 Jan 2013 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/95740/Support for 15,000 Partitions in SQL Server 2008 SP2 and SQL Server 2008 R2 SP1In SQL Server 2008 and SQL Server 2008 R2, the number of partitions on tables and indexes is limited to 1,000. This paper discusses how SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 address this limitation by providing an option to increase the limit to 15,000 partitions. It describes how support for 15,000 partitions can be enabled and disabled on a database. It also talks about performance characteristics, certain limitations associated with this support, known issues, and their workarounds. This support is targeted to enterprise customers and ISVs with large-scale decision support or data warehouse requirements.]]>http://www.sqlservercentral.com/redirect/articles/74197/Thu, 09 Jun 2011 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/74197/Automate Sliding Window Partition Maintenance: Part IIIPart 3 of Hugh Scott's series on automating sliding window partitions in SQL Server using PowerShell]]>http://www.sqlservercentral.com/articles/Partitioning/71657/Fri, 21 Mar 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/71657/Automate Sliding Window Partition Maintenance: Part IIPart 2 of a series on how to automate partition management. In this article learn how easy managing and maintaining a sliding window partition scheme can be with PowerShell.

How to track every change to your SQL Server databaseSee who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more.

]]>http://www.sqlservercentral.com/articles/Partitioning/71656/Fri, 14 Mar 2014 06:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/71656/Automate Sliding Window Partition Management: Part IA new series on how you can automate partition management and administration. Hugh Scott explains how this technique helps him manage large deletes.

Library of articles for Database Lifecycle ManagementDiscover a collection of articles covering important checkpoints on the journey of database lifecycle management - including team processes, version control and release management. Find out more on Simple-Talk.

]]>http://www.sqlservercentral.com/articles/Partitioning/71655/Fri, 07 Mar 2014 07:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/71655/Partitioning in SQL Server 2008This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.]]>http://www.sqlservercentral.com/articles/partition/64740/Fri, 01 Oct 2010 06:00:00 UThttp://www.sqlservercentral.com/articles/partition/64740/Improving Performance of Cross-Partition QueriesTable partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.]]>http://www.sqlservercentral.com/articles/Partitioning/69898/Tue, 04 May 2010 06:00:00 UThttp://www.sqlservercentral.com/articles/Partitioning/69898/Cube Storage: Planning Partitions from a SQL Server Management Studio PerspectiveBI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.]]>http://www.sqlservercentral.com/redirect/articles/69024/Wed, 16 Dec 2009 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/69024/Partitioning in SQL Server 2008This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.