Pro Tips on Managing Data at Scale
As a DBA I worked on a number of projects fighting fires and putting them off successfully. However in the beginning of my career I was not sure where to start, as I matured as a DBA there is a pattern that developed to troubleshoot performance issues. Each of the following areas need different kind … Read more
If you are looking to generate load from cursor command for a bunch of schema’s at once, this SQL is your friend!
Problem: As a DBA, you may get asked by development/other teams to get the list of duplicate rows based on a certain column or a key (non-primary). In this short blog post I am going to discuss a couple of ways to get the list of duplicates. Solution: For e.g. lets assume you have a … Read more
Problem Statement: You are trying to figure out if there are any Foreign key constraints in your database with out the corresponding Index. If you are working in an OLTP environment you already know most of your query patterns include a join on primary key (parent table) and foreign key(s) (child tables). It is important … Read more
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.