What should be our precautions and strategies to avoid a Deadlock in a Database System. We should use clustered index maximum for all types of transaction. The clustered key stored in the same data page so whenever we are updating or deleting data, it saves the data searching time. You should always write UPDATE and […]

I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architect, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL, Greenplum and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.