We use SUM Function to calculate the sum of values in a column. SUM is a aggregated function and generally we use it with …
Read More »ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
When you try to import the export from a database on Exadata to a database that is not on Exadata storage, Pillar Axiom storage …
Read More »“Database ‘x’ cannot be opened due to inaccessible files or insufficient memory or disk space” and “Initializing/Recovery Pending”
There may be several reasons for this error. A friend of mine said that when he received this error, the database files were deleted. …
Read More »STRING_AGG Function in SQL Server(TSQL)
We can concatenate string columns with STRING_AGG function. STRING_AGG function requires 2 argument. Thats why we must put seperater between values. Let’s make examples …
Read More »ORA-08104 error received during index rebuild process
During the process of an online index rebuild operation, when the related session is unexpectedly interrupted, even though there is no rebuild process, it …
Read More »How To Move Msdtc Disk To Another Storage
To move the MSDTC disk to another storage, we need to remove MSDTC from the cluster and then re-add to the cluster. To remove …
Read More »FIRST_VALUE Function in SQL Server(TSQL)
We have mentioned the LEAD and LAG functions announced with SQL Server 2012. In this article, we will examine the FIRST_VALUE function. Now let’s look …
Read More »LEAD and LAG Functions in SQL Server(TSQL)
As a consultant and training provider in business intelligence projects on SQL Server, some analytic functions I expected to be announced for a long time …
Read More »Hybrid Columnar Compression
Hybrid Columnar Compression (HCC) introduced with Oracle Database 11g Release 2. HCC is a feature that can be used with Exadata storage, Pillar Axiom …
Read More »How To Move Quorum Disk To Another Storage
First, you should request two 5 GB disks from new storage. These 2 disks must be visible to all servers included in the windows …
Read More »