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

  There was a license-related change in the edition of Enterprise Edition in SQL Server 2012. There are two Enterprise Edition Models. Enterprise Edition with …

  We can set the first day of the week for a session with SET DATEFIRST Statement. We can query the first day of the …

  It is possible to find the privileges granted to a user with the data dictionary views. The main views that can be used are …

  You may receive an error as follows when you want to start SQL Server Service. You need to look at the event viewer.  Write …

  IDENT_SEED function returns the value of the seed you specified when creating the identitiy column. The value returned by this function does not change …

  We can set a parameter in the Oracle database to its default value. The reset process is only performed in the spfile. The parameter …

  TSQL Developers sometimes want to use the same code block in more than one place when writing a query. Sometimes this case can complicate …

  The following operations can be performed with the DBCC CHECKIDENT command. The current identitiy value of an identity column can be found. The maximum …

  During the insert operation to the tables, ORA-600 [ktspfhsp-9] error is received due to various bugs and corruption in the segments of the table. …

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