How To Change Instance Settings in SQL Server
In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS…
0 Comments
December 27, 2019
Multitenant Database in Oracle
What is a Multitenant Database? As of version 12.1, you can design your databases as a multitenant database (CDB). It…
December 27, 2019
Version Store Space Usage in Tempdb(sys.dm_tran_version_store_space_usage)
With SQL Server 2017, a new dmv named sys.dm_tran_version_store_space_usage was announced to find out which database uses how much space…
December 26, 2019
“library cache lock, gc cr request and gc buffer busy acquire” Wait Events After Upgrade to Oracle 12.2
When the Exadata database is upgraded to version 12.2, "gc cr request" and "gc buffer busy acquire" wait events occur…
December 26, 2019
SELECT INTO On Filegroup
Tables created with SELECT INTO prior to SQL Server 2017 could not be created on a filegroup other than the…
December 25, 2019
ORA-08102: index key not found
During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you…
December 25, 2019
Automatic Tuning in SQL Server
What is Automatic Tuning in SQL Server? Automatic Tuning is announced with SQL Server 2017. Automatic Tuning is a database…
December 24, 2019
![ORA-00600: internal error code, arguments: [qcsprfro_tree:jrs present]](https://dbtut.com/wp-content/uploads/2019/11/Adsız-58.png)
ORA-00600: internal error code, arguments: [qcsprfro_tree:jrs present]
Due to an unknown situation in Oracle 11g databases, "ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]" error is received…
December 24, 2019
Resumable Indexes in SQL Server
What is Resumable Index? When rebuilding indexes online, index rebuild process could be fail for reasons such as failover, disk…
December 23, 2019
How To Convert A Non-Partitioned Table To Partitioned Table Online in Oracle Using DBMS_REDEFINITION
With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We…
December 23, 2019