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

  If you have consolidated your databases, you may want to identify and remove unused databases after some time. In such a case, we need …

  With the IDENT_INCR function we can find the incremental value of the identity column in a table. If there is no Identity column in …

  Partitioned table cannot be moved like a normal table. Therefore, partitions need to be moved separately. In order to prevent the table from creating …

The online rebuild feature came with SQL Server 2005 to prevent the application from being affected while rebuilding the indexes. However, according to my personal …

  We will examine TRY_CAST and TRY_CONVERT functions in this article. You can find more informartion about CAST and CONVERT functions in the article below. …

  During the drop operation of the event records on the Exadata cell node, when we try to delete individual records created for the problem, …

  When we have a performance problem in the database, the first thing we do is to list current queries using dmws. You can find …

  You can specify the date format that the corresponding session accepts with “SET DATEFORMAT”. You may need this command if you want to assign …

  Events that are automatically recorded when a problem occurs on the Exadata cell node must be cleared when the problem is corrected. The cleaning …

  Your queries are running slow and you want to determine which queries are running slowly. You can perform this operation by using SQL Server …