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

  I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …

  During a typical revision of mongod’s logs, we could find slow queries, by default, those queries that take more >100ms. You can change this time …

Error : When we logged in to EM, there was an error “java.lang.Exception: Exception in sending Request :: null” and the page was not displayed …

  We can not take the backup of the database and transfer it to the test environment for security reasons. Because the actual data should …

  Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …

  1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate the memory size and database …

  It is a good idea to save the database server’s log output somewhere, rather than just routing it to /dev/null. The log output is invaluable when …

PostgreSQL, like any database software, requires that certain tasks be performed regularly to achieve optimum performance. The tasks discussed here are required, but they are repetitive in nature …

Overview This article briefs us on how to tune a database or make it work faster Max connections: We can configure the maximum number of …

Database Tuning Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply …