Latch free and library cache: mutex X wait events can be seen for the corresponding SQL statements in intensive delete and insert operations in …
Read More »What is Application Role in SQL Server
Application Role is a role at the database level. You can use Application Roles to access a database only with specific users from a …
Read More »SQL Server Metadata Functions
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 …
Read More »ORA-12805: parallel query server died unexpectedly error in 12c databases
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 …
Read More »How To Grant Permissions To Run Job in SQL Server
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 …
Read More »Why Oracle User is Locked, Who is Locking Oracle User
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 …
Read More »SQL Server Agent Fixed Database Roles
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 …
Read More »CHOOSE and IIF Functions in SQL Server
CHOOSE and IIF functions are logical functions. CHOOSE function returns the value at the specified index from the specified list. IIF function performs the …
Read More »INS-35354 error received when RunInstaller is run
On an Oracle RAC server, you may receive an error as follows when you want to create a new database with runinstaller. INS-35354: The …
Read More »What is Spatial Index in SQL Server
Spatial Index can only be created on Spatial columns. That is, the type of column must be geometry or geography. Let’s create a table …
Read More »