Rahul Gupta has had more than a decade of experience in data modelling, database design, business and technical analysis working for various companies such as Tata Consultancy Services, Philips, CGI, and Deloitte.
As table size grows due to more data, the performance of insert, update, delete and select SQL operations, as well as maintenance operations tasks such as taking backups, index maintenance and update statistics may take longer to perform. In order to improve the performance of these operations it is therefore advisable to partition tables greater than 2GB in separate chunks… Read more
In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.… Read more