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

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 …

  If an oracle user is locked, it is usually caused by an incorrect password entry. In some cases, even if you remove the user’s …

A login must have authority over some database roles in the msdb database in order to access SQL Server Agent. These roles in the msdb …