Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We can find the difference between the two dates using the following dateparts with the DATEDIFF function. The return data type is int. If …
Read More »dbtut
Increasing the performance of global cache service(LMSn) in Oracle
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 …
Read More »Make Sure that Database Mail is running in SQL Server(Failsafe Operator)
Before reading this article, I recommend that you read the articles “How To Configure Database Mail on SQL Server” and “How to Create an …
Read More »DATEADD Function in SQL Server(TSQL)
With the DATEADD function we can add or remove a datepart to a date. Below is a list of the dateparts we can add. …
Read More »Configure Automatic Memory Management in Oracle
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 …
Read More »SQL Server Edition Upgrade(SQL Server does not use all assigned CPUs)
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 …
Read More »SET DATEFIRST Statement and @@DATEFIRST Function in SQL Server(TSQL)
We can set the first day of the week for a session with SET DATEFIRST Statement. We can query the first day of the …
Read More »Find Privileges Granted to a User in Oracle
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 »