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

  If an oracle user is locked, it is usually caused by an incorrect password entry. In some cases, even if you remove the user’s …

A login must have authority over some database roles in the msdb database in order to access SQL Server Agent. These roles in the msdb …

  CHOOSE and IIF functions are logical functions. CHOOSE function returns the value at the specified index from the specified list. IIF function performs the …

  On an Oracle RAC server, you may receive an error as follows when you want to create a new database with runinstaller. INS-35354: The …

  Spatial Index can only be created on Spatial columns. That is, the type of column must be geometry or geography. Let’s create a table …

  SQRT function returns the square root of a float value and the return data type is float. SQUARE function returns the square of a …

  When the “AVDF transaction log audit trail” is created and deleted, the archive logs cannot be deleted normally, depending on bug 23217905. The problem …

  The Filtered Index is a filtered nonclustered index. For example, you have 100,000 records in a table. And some of your queries are only …

  The SIGN function determines whether a number is negative, 0, or positive. If the number is negative, it returns -1, If the number is …

With ADRCI, it is possible to delete files such as “log, trace, incident, cdump” created before a certain day. Instead of manually deleting individual files, …