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

With BULK INSERT you can upload text, csv data files to the database in any format. Users must have insert privileges in the database and …

We often need to get information about existing sessions in databases. We can find the below details with the help of the following query. Which …

With OPENROWSET, you can access remote data using OLE DB. OPENROWSET is a system function as you will see below. With this method, we provide …

If a user want to drop a DB link belonging to a schema in Oracle databases, it searches for that DB link under the schema …

What is Query Hint? You can change the execution plan of the query by adding the query hints to the end of the query. For …

The most recent password change date for users in the Oracle database is in the ptime field in the sys.user $ table. With a query …

In this article, we will examine what happens when we enable Optimize for ad hoc workloads and when we use parameterization. We will see what …

Any problem with multicast traffic between Oracle RAC database servers can cause network heartbit problems between servers. In this case you need to see the …

In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a …

sp_create_plan_guide introduced with sql server 2005. With this sp, you can increase the performance of your queries that you can’t intervene or change, by adding …