MSSQL

  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 …

  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 …

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 …

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 …

  First, you should request two 5 GB disks from new storage. These 2 disks must be visible to all servers included in the windows …

  We find the minimum value in a column in a dataset, with the MIN Function and we find the maximum value  in a column …

In this article I will show you how to validate windows cluster configuration step by step with screen shots. You can perform validate configuration to …

  The COUNT_BIG function performs the same function as the COUNT function. The only difference is that the COUNT_BIG function returns the BIGINT value while …

  Sometimes we need to move the database from one instance to another instance. But we don’t dare to erase our old database right away. …

  We find the number of records in a data set with the Count function. For example, we can find the number of records in …