Large Data Handling in SQL Sever- Purging & Archiving & Partitioning

Best methods to fallow the Purging & Archiving & Partitioning in SQL Server

[kareemabdul]

This video is outstanding.Recently we face this issue while archive log file got full.with the help of this video now I can suggest our developer to perform like this.

[danieltsvetkov]

Great explanation and excellent solution proposals to the large tables problem! Thank you and keep up the good work!

[azeezullasheriff]

Excellent, Raj.. keep the Good work going on.
I have forwarded this to my team, who do regular archives to include your best practices

[bluerays]

Good Learning today Sir, Thank you for Sharing.

[saket]

Good explication👌while archiving 1st time, why can't we use Select * into Employee_History_Arc From Employee_History; instead of batch processing? Hope optimiser utilize batch processing internally and may not occur any locking or blocking situations. Deletion should be done in batch processing.

You could have given more explanation on best practices to implement archival solution. Like how to analyse tables, what all are the tables need to be taken from a DB to archive, what would be the the impact on U I application if we archive certain tables etc.

[tanveerkarbelkar]

​ @RajasekharReddy Bolla sir I have two questions in this regard:
1. As the data is moved to T2, will it create less load on T1 for DML statements? Further, when you query T1 as part of the union, will it perform better than a single table?

2. If we create T1 & T2 two tables, is there a way we can create a single unique constrain on a single field combining both these tables?

[aanchalsrivastava]

Can u tell in mysql how to create stored procedure that purge the data of table for defined period of time

[rahulnepalallinone]

Hello, could you please make a video on performance tuning that help us alot.also please suggest if there any link or website that hepl for learning dept in to performance tuning.

[himanish]

If dimension table is continuously increasing then how do we manage ??

[kanakapavan]

Hi Rajasekhar I have Doubt Regarding Data Archiving, While Main Table Some Data Inserted into Arch Table Strcuture. When ever we required data into Main Table then what need to do.
1) Is again insert Arch table data to Main table.

Please Suggest me, Let me Correct if any thing Wrong.