Jacob Wilkins (11/23/2015)

---

There are a couple problems that seem to be copy/paste issues, and then a couple others.

First, the As Partition YearlyDateRange_pf All To ([Primary]) bit at the end of...

Thanks!

Could you please take a crack at correcting the syntax?

Thanks for the information.

I have already created an Archive Database with a Lookup table used to control the batch size and the WHILE Loop.

Edit: Not sure to do with the...

I would prefer to archive the database using code that I already wrote.

I do not see any value added in partitioning the table.

Another thing is that the current file groups...

Thanks Scott.

The current indexes could be a lot better.

The main problem is that the tables are so large.

They have old data which needs to be archived

Another issue is that the...

I think that partitioning the tables is not the best approach.

There are hundreds of Stored Procedures and embedded T-SQL in .NET Code.

It could be a disaster.

All I need to do...

Luis Cazares (11/20/2015)

---

Partitioning tables is a great tool to manage the archiving process for large tables. However, this is something that has to be well planned and consider all the...

What circumstances do you consider in making an Index aligned or not?

I have googled but I have not found a straight forward answer.

Thank you.

Thanks Gail.

Could you please provide me a few reason to do both?:unsure:

I am a lot more clear after reading the following articles:

http://blogs.msdn.com/b/felixmar/archive/2011/02/14/partitioning-amp-archiving-tables-in-sql-server-part-1-the-basics.aspx

http://blogs.msdn.com/b/felixmar/archive/2011/08/29/partitioning-amp-archiving-tables-in-sql-server-part-2-split-merge-and-switch-partitions.aspx

What is really interesting is that all of the data files are on the same drive.

I had written code to archive tables into an Archive Database because some tables are very large and it is having an adverse impact on performance.

That was simple but I'm...

SQL Server 2012 Enterprise Edition SP2. Moving to 2014, probably soon.

Please let me know what other information that need to make a determination.

Jeff Moden (11/9/2015)

---

Welsh Corgi (11/9/2015)

---

I have written a Stored Procedure to Archive Tables.

I have been asked to Partition the tables.

Would I be better off to hold off on the archiving...

I created a new solution and now the Data Source tasks and data destination tasks are not visible.

What am I missing?

Thanks.