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

  In a replica set if one of the members is in RECOVERING state and in the log file of that member if you see: [crayon-684b1f1310051032452854/]   …

  Assume that the default temp table space of the system is TMP. ERROR: ORA-01187: can not read from file because it failed verification tests …

  In SQL Server, sometimes you do not want anyone to see the contents of an important column in an important table. In such a …

  Steps to Install & Configure MySQL 3-Node Galera Cluster on CENTOS Step 1: Enabling the Galera Cluster yum repositories. [crayon-684b1f1310a2a904865288/]   Step 2: Install …

  Assume that the user receiving the error is SCOTT. In this case a checklist should be created for the SCOTT user. You can use …

  Percona Xtrabackup is  open source  backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing …

You may want to move a database containing “File Stream” data to another disk with the detach attach method. Moving a database containing “File Stream” …

  It is a setting made on windows so that SQL Server can work with higher performance. This setting can be made on Windows Server …

ERROR : OC4J Configuration issue. <ORACLE_HOME> / oc4j / j2ee / OC4J_DBConsole_ <SERVER> _ <SID> not found. SOLUTION : The passwords of sysman and dbsnmp …

  Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB …