NBCampus_Exclusive

Linearly Increasing Same Digit Decimal Numbers

 Linearly Increasing Same Digit Decimal Numbers Identify the pattern Identifying correct pattern is the key to apply a trick successfully. If you make mistake in identifying the pattern, you may calculate to wrong answer. Thus, request you to pay special attention in identifying the correct pattern Pattern to apply this trick – .A + .AA …

Linearly Increasing Same Digit Decimal Numbers Read More »

Quick Mental Addition (हिन्दी & English)

 Quick Mental Addition (हिन्दी & English) हिन्दी मे Video Video in English If you need to add 2 large numbers, it may become complex and time consuming. Specifically for candidates who are preparing for competitive exams as they can not afford to waste even a second extra. I have a very simple and ultra quick …

Quick Mental Addition (हिन्दी & English) Read More »

fix the import org.apache.common.lang3 can not be resolved (हिन्दी में …)

fix the import org.apache.common.lang3 can not be resolved (हिन्दी में …) “the import org.apache.common.lang3 can not be resolved” is very common error message for Java developers. But, it is quite difficult to fix for beginner. You must import the parent class before to use string method StringUtils. For example, you should import java.util.List before using …

fix the import org.apache.common.lang3 can not be resolved (हिन्दी में …) Read More »

PrimaryKey on existing Unique index in PostgreSQL Database

PrimaryKey on existing Unique index in PostgreSQL Database Indeed PrimaryKey is most important to force data uniqueness in the database table. Specifically, PostgreSQL database allow to create PrimaryKey on a single column and on a combination of candidate columns as well. Furthermore, the Later case is known as composite primary key. When we create PrimaryKey …

PrimaryKey on existing Unique index in PostgreSQL Database Read More »

PostgreSQL – Database slowness caused by shared buffer contention.

 PostgreSQL – Database slowness caused by shared buffer contention. Issue : PostgreSQL – Application team reported response slowness. Environment:PostgreSQL 9.6 cluster with primary-standby configuration. Any recent change in environment: A new agent was on-boarded. Investigation: Sever I/O and CPU utilization : iostat -x 1 1000 Note:  CPU utilization was 99.4% and it’s consumed by users …

PostgreSQL – Database slowness caused by shared buffer contention. Read More »

PostgreSQL find delete duplicate records in simple ste

PostgreSQL – How to find and delete duplicate records PostgreSQL – how to find and delete duplicate records ? Lot of developers have asked this question. Therefore, in this tutorial I have explained these steps in very simple manner. In the below mentioned video, you can learn these steps while watching rather than reading. Demo …

PostgreSQL find delete duplicate records in simple ste Read More »

PostgreSQL – database crashed as pg_xlog utilization reached 100%

 PostgreSQL – database crashed as pg_xlog utilization reached 100% Issue : PostgreSQL – database cluster crashed as pg_xlog was 100% full Environment: PostgreSQL 9.6 cluster with primary-standby configuration, having 2 replication slots. Any recent change in environment: Another DBA triggered AWS DMS task to migrate database to Aurora PostgreSQL. Immediate action taken to start the …

PostgreSQL – database crashed as pg_xlog utilization reached 100% Read More »

Shopping Cart