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

  We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. …

  When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of …

When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob …

  The “Cursor Mutex S” wait event occurs when two different sessions try to make hard or soft parsing on the same query. As a …

  ColumnStore Index entered our lives with SQL Server 2012.  Normally the index is stored in the disk as row-based, and the index is created …

  We can find the difference between the two dates using the following dateparts with the DATEDIFF function. The return data type is int. If …

  The global cache service (LMSn) processes copy consistent copies of blocks in the buffer cache to the requesting instance’s foregound process. LMS also performs …

  Before reading this article, I recommend that you read the articles  “How To Configure Database Mail on SQL Server” and “How to Create an …

  With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add. …

To configure Automatic Memory Management(AMM) in databases that do not use AMM, it is necessary to change the required parameters and restart the database. When …