Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
It is possible to find the privileges granted to a user with the data dictionary views. The main views that can be used are …
Read More » Server TCP provider failed to listen on [ ‘any’ 1433]. Tcp port is already in use.
You may receive an error as follows when you want to start SQL Server Service. You need to look at the event viewer. Write …
Read More »IDENT_SEED Function in SQL Server(TSQL)
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 …
Read More »How To Reset an Oracle Database Parameter
We can set a parameter in the Oracle database to its default value. The reset process is only performed in the spfile. The parameter …
Read More »Common Table Expression(CTE)
TSQL Developers sometimes want to use the same code block in more than one place when writing a query. Sometimes this case can complicate …
Read More »DBCC CHECKIDENT in SQL Server(TSQL)
The following operations can be performed with the DBCC CHECKIDENT command. The current identitiy value of an identity column can be found. The maximum …
Read More »ORA-600 [ktspfhsp-9]
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. …
Read More »Using Extended Events To Determine Whether The Database Is Being Used
If you have consolidated your databases, you may want to identify and remove unused databases after some time. In such a case, we need …
Read More »How To Identify Tables that has identity columns in a database? and what are incremental values of these identitity columns?(IDENT_INCR Function)
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 …
Read More »How To Move a Partitioned Table To New Tablespace in Oracle
Partitioned table cannot be moved like a normal table. Therefore, partitions need to be moved separately. In order to prevent the table from creating …
Read More »