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

Docker, which is becoming increasingly popular, is in the logic of virtualization. But unlike conventional known virtualization tools(Virtualbox, Vmvare ,kvm vb.. ), it does not …

  OUTPUT Clause transfers the records affected by the currently executed INSERT, UPDATE, or DELETE operations to the specified table. So we can easily capture …

enq: TX – row lock contention can be regarded as a row lock conflict wait event in operations. This event indicates that a session is …

We can create a user without login since SQL Server 2005 version. This feature was introduced instead of Application Role. You may want to read …

  These are the special sorting functions that we can use to sort the data that we select from the tables at run time. ROW_NUMBER …

  Latch free and library cache: mutex X wait events can be seen for the corresponding SQL statements in intensive delete and insert operations in …

  Application Role is a role at the database level. You can use Application Roles to access a database only with specific users from a …

I will tell you below metadata functions in this article. APP_NAME COL_LENGTH DATABASEPROPERTYEX SERVERPROPERTY DB_ID DB_NAME OBJECT_ID OBJECT_NAME SCHEMA_ID SCHEMA_NAME STATS_DATE APP_NAME Function: This function …

In 12c databases, ORA-12805, ORA-07445 [qertqistart] or ORA-600 [15803] errors may occur depending on bug 25694206. User operation cannot be completed due to the closing …

Before you begin this article, I suggest you read my article “How To Create a Login On SQL Server(Manage Logins)” for a detailed review of …