What is DeadLock? Although it is like a movie star, it causes serious problems in applications. If we want to briefly summarize DeadLock, two or …
Read More »How To Capture DeadLocks With Extended Events
Application developers sometimes receive a deadlock error and cannot see which queries are deadlocked. That’s why they demand this information from you. We can capture …
Read More »How to Find Locks on Library Cache Objects
We can see the locks on Library cache objects in V$ACCESS (GV$ACCESS on RAC systems). The dependency on objects is managed by library locks. …
Read More »the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine
You may receive this error when you want to import data from a file such as Excel to the sql server. You must install …
Read More »GROUPING and GROUPING_ID Functions in SQL Server(TSQL)
We can create subtotal and grandtotal rows for the grouped data with WITH ROLLUP, WITH CUBE and GROUPING SETS operators. You can find details …
Read More »WITH ROLLUP and WITH CUBE Operators in SQL Server(TSQL)
We use the WITH ROLLUP and WITH CUBE operators with the GROUP BY statement. So before you read this article, I suggest you read the …
Read More »GROUPING SETS Operator in SQL SERVER(TSQL)
SQL Server supports grouping of data with GROUP BY since older versions, and also offers WITH ROLLUP and WITH CUBE operators for grand-total and sub-totals. …
Read More »CHECKSUM_AGG Function in SQL Server(TSQL)
Creates a checksum value of a data set. You can use it to check if data in a column is being modified. accepts int …
Read More »How To Change the Cluster interconnect and public interface in RAC databases
In RAC databases, serious cluster wait events are seen, usually due to the low speed of interconnect interfaces. Therefore, after the installation, faster hardware interfaces …
Read More »User, group, or role already exists in the current database
You moved the database to another instance and created a new login for this database instead of moving the login from the old instance …
Read More »