Let’s assume that the sql_id of the query that we will improve is “bjyanqt9q718f”. First of all, we run the following procedure and create …
Read More »Script To Gather Statistics On Table and Indexes On DB2
RUNSTATS utility perform statistics in DB2. Should be perform Weekly or Monthly basis. Following Script helps to gather statistics on all tables excluding XML …
Read More »DB2 Online DB backup Script
Following script is useful when you have multiple databases on single instance. When you need to provide your operation team to take backup of DB1 …
Read More »PostgreSQL – Insert on conflict(Upsert)
With PostgreSQL, it is very easy to manage the case “update if there is a record, if not, add”. In traditional methods, we first …
Read More »Readable Secondary On SQL Server Always On Availability Group
In Always On Availability Group Architecture, you can read from the Secondary Server. So how do you use it in your applications? In this …
Read More »Run Your Jobs With a Proxy Account
As you know, when you define SQL Server services through sql server configuration manager, they are automatically authorized with the minimum privileges they may …
Read More »PostgreSQL DBLINK
In this article I will describe how to connect to remote PostgreSQL database with PostgreSQL dblink. Dblink usage is similar to other databases. but …
Read More »Health Instance Monitoring on MongoDB Cluster
Script to monitor Health Instance on MongoDB Cluster [crayon-6627fe4b2cc4d406877020/] Note: Requires username and password with RootPrivileges.
Read More »How To Export Table/QueryResult To CSV File On PostgreSQL
PostgreSQL supports the CSV file format as a native. You can import data from a CSV file and add it to a table, or …
Read More »INITRANS benefit in tables and indexes with high I/O
If you increase the INITRANS parameter in tables and indexes with very high I/O, it will make less I/O because multiple operations can be …
Read More »