Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

  PostgreSQL supports the CSV file format as a native. You can import data from a CSV file and add it to a table, or …

  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 …

  When creating a SQL Login, you can select the Enforce Password Policy option as described in my article “How To Create a Login On …

  After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows for the performance of SQL …

  You can use the between command (including the first and last value) to read the data between the two values in the table in …

  First, delete previous delimiter files which were offloaded from the archive log. This can be regenerated. [crayon-68621a73c5148249375144/]   Below command will archive Instance level …

First, check audit parameter in DB2 LUW; as you can see “audit active” is FALSE, which shows that currently auditing is not enabled on your instance. …

As with most database systems, PostgreSQL offers us various system functions to easily calculate the disk size of the objects. We can get the size …

  With the flashback database feature, the hours-long restore-recover process can be completed in a few minutes. You can roll back and open your database …

  Microsoft has announced that it will remove Database Mirroring in the future because it has developed the Always On technology. But since SQL Server …