We can set a session’s language With SET LANGUAGE Command. This command affects the system datetime format and system messages. If you want to …
Read More »The Extended Events session named “x” could not be found. Make sure the session exist and is started.
One day I opened SSMS (SQL Server Management Studio) and wanted to check the Extended Events Session that captured Timeouts. To find out how …
Read More »SUM Function in SQL Server(TSQL)
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 »