SQL Server Script to Rebuild/Reorganize Fragmented Indexes When on a database’s table frequently running INSERT, UPDATE or DELETE queries than we can see indexes on the particular table gets fragmented and the SQL query may run slower as they may choose the non-optimal execution plan. Most of the people asking about Does SQL Server rebuild index automatically or any rebuild criteria? But Rebuilding/Reorganize of fragmented Indexes not supported automatically because rebuilding the indexes is expansive operation so be careful to schedule rebuilding via SQL Server Agent. But hare we are adopting an approach to rebuild or Reorganize only the necessary Indexes instead of all index rebuild, As a general recommendation, the index needs to rebuild that gets fragment percentage more than 30% and reorganize the index that has fragment percentage greater than 10% and less than 30%. The below script rebuilding index one by one, so it won’t be an expansive operation on the production database. --- Rebuild/Reorganize Indexes CREATE TABLE #IndexRebuild ( DatabaseName SYSNAME, SchemaName SYSNAME, TableName SYSNAME, IndexName SYSNAME, [Fragmentation%] FLOAT ) INSERT INTO #IndexRebuild SELECT DB_NAME(DB_ID()) AS DatabaseName, ss.name AS SchemaName, OBJECT_NAME (s.object_id) AS TableName, i.name AS IndexName, s.avg_fragmentation_in_percent AS [Fragmentation%] FROM sys.dm_db_index_physical_stats(db_id(),NULL, NULL, NULL, 'SAMPLED') s INNER JOIN sys.indexes i ON s.[object_id] = i.[object_id] AND s.index_id = i.index_id INNER JOIN sys.objects o ON s.object_id = o.object_id INNER JOIN sys.schemas ss ON ss.[schema_id] = o.[schema_id] WHERE s.database_id = DB_ID() AND i.index_id != 0 AND s.record_count > 0 AND o.is_ms_shipped = 0 AND s.avg_fragmentation_in_percent > 10 DECLARE @RebuildSQL NVARCHAR(MAX) SET @RebuildSQL = '' SELECT @RebuildSQL = @RebuildSQL + CASE WHEN [Fragmentation%] > 30 THEN CHAR(10) + 'ALTER INDEX ' + QUOTENAME(IndexName) + ' ON ' + QUOTENAME(SchemaName) + '.' + QUOTENAME(TableName) + ' REBUILD;' WHEN [Fragmentation%] > 10 THEN CHAR(10) + 'ALTER INDEX ' + QUOTENAME(IndexName) + ' ON ' + QUOTENAME(SchemaName) + '.' + QUOTENAME(TableName) + ' REORGANIZE;' END FROM #IndexRebuild WHERE [Fragmentation%] > 10 DECLARE @StartOffset INT DECLARE @Length INT SET @StartOffset = 0 SET @Length = 4000 WHILE (@StartOffset < LEN(@RebuildSQL)) BEGIN PRINT SUBSTRING(@RebuildSQL, @StartOffset, @Length) SET @StartOffset = @StartOffset + @Length END PRINT SUBSTRING(@RebuildSQL, @StartOffset, @Length) EXECUTE sp_executesql @RebuildSQL DROP TABLE #IndexRebuild The scripts will work like a charm, You can create a stored procedure and can call the stored procedure via the SQL Server agent or via windows task scheduler.

How do you add Axis Labels on to both x-axis and y-axis? (Chart.js)

pradeepkumarjse

I have a chart.js running, but i really want to add axis names on teh axises, but dont know how. Could i get some help?

I have tried to figure it out by searching up, but can't find anything that explain it well.

What is am trying to get:

My chart code:

    const ctx = document.getElementById('chart').getContext('2d');
    window.myChart = new Chart(ctx,{ // having the "myChart" as a window. insted of const was sugested by someone on StackOverflow (makes the const global, i can therefor use it in another function)
        type: 'line',
        data: {
            labels: arrayTheta,
            datasets: [{
                //label: graphLabels,
                data: arrayRangeArray[0],
                backgroundColor: 'rgba(255, 99, 132, 0.2)',

                borderColor: 'rgba(255, 99, 132, 1)',
                pointRadius: 0,
                tension: 0.4  //The line "tension: 0.4" makes the graph a little bit smoother (might remove later)
            },
            {
              //label: graphLabels,
              data: arrayRangeArray[1],
              backgroundColor: 'blue, 0.2',

              borderColor: 'blue',
              pointRadius: 0,
              tension: 0.4

            },
            {
              //label: graphLabels,
              data: arrayRangeArray[2],
              backgroundColor: 'pink, 0.2',

              borderColor: 'pink',
              pointRadius: 0,
              tension: 0.4

            },
            {
              //label: graphLabels,
              data: arrayRangeArray[3],
              backgroundColor: 'orange, 0.2',

              borderColor: 'orange',
              pointRadius: 0,
              tension: 0.4

            },
            {
              //label: graphLabels,
              data: arrayRangeArray[4],
              backgroundColor: 'yellow, 0.2',

              borderColor: 'yellow',
              pointRadius: 0,
              tension: 0.4

            },
            {
              //label: graphLabels,
              data: arrayRangeArray[5],
              backgroundColor: 'black, 0.2',

              borderColor: 'black',
              pointRadius: 0,
              tension: 0.4

            }],
        },
        options: {
            scales: {
                y: {
                    beginAtZero: true
                }
                ,x: {
                  display: true,
                  type: 'linear'
                }
            }
        }
    });

It would be awesome if someone could implement it into my code and the send it here.

Thanks in advance!!