Useful tips for everyday
How does SQL Developer connect to Oracle Server? Configure Oracle SQL Developer Cloud Connection Run Oracle SQL Developer locally. The Oracle SQL Developer home page…
How do you optimize an ETL? Reduce Data as Early as Possible The earlier the amount of data can be reduced, the less work has…
Why are indexes so bad in SQL Server? Poorly designed indexes and a lack of the same are primary sources of poor SQL Server performance.…
What is index fragmentation in database? SQL Server index fragmentation is a common source of database performance degradation. Fragmentation occurs when there is a lot…
How do I enable a password login instead of a key pair when logging into my EC2 instance using SSH? How to Enable Password Authentication…
Where is the maintenance plan Wizard in SQL Server? Object Explorer only displays the Maintenance Plans node for users who are members of the sysadmin…
How to create custom sequence in Oracle SQL? My trigger for Parent Item generates Sequence as “P2505” and I want my sub-Items Sequence should be…
How to add unique columns to two tables? Join two tables, selecting all columns (columns with ambiguous names will not be included or assigned a…
How to change column datatype from VARCHAR2 to NUMBER in Oracle? 3 Answers create another column with NUMBER data type let’s say “NUMBER1” . add…
How do I know if an SSIS package failed? In the Solution Explorer, Right-click on the SSIS package and click on Execute. The Red-Cross icon…