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

[@danieltsvetkov695]

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

[@kareemabdul9730]

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.

[@azeezullasheriff7746]

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

[@bluerays5384]

Good Learning today Sir, Thank you for Sharing.

[@saket6]

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.

[@aanchalsrivastava8550]

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

[@zawlinhtet4654]

Thank you for very useful info 🙏

[@P5toraskar1986]

Good explanation thank you so much.

[@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?

[@ZaneT531]

Nice tutorial man..

[@ChennaiChannel]

Thanks for sharing.. useful

[@himanish2006]

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

[@rahulnepalallinone1794]

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.

[@panchadhara28]

great video

[@bhishambajaj8242]

Gold content

[@krisharjunakinjarapu3071]

Where i can get all the videos

[@rajasekhar_reddy_bolla]

Can u contact me [phone]

[@kanakapavan4286]

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.

[@rajasekhar_reddy_bolla]

just use union like select * from T1 union select * from T2. You don't need to keep the data again to main table

[@avinash8535]

@@rajasekhar_reddy_bolla Hi Sir, can you please make a video on performance tuning with large tables like 10M+ data.. Tips and tricks other than indexes, temp tables, etc.. Please??

[@rajasekhar_reddy_bolla]

@@avinash8535 Sure Avinash 😀

[@tanveerkarbelkar]

​@@rajasekhar_reddy_bolla sir i have two questions in this regards: 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 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 ?

[@diamondhand5018]

02:00

[@mounikayakar1479]

Mssql tips