dnd 5e – How can I either heat air for a balloon or heat another material to power a machine, without consuming fuel?

Create Bonfire might work

Create Bonfire creates a self-sustaining magic fire that lasts for 1 minute. However, as it is a cantrip, you can repeatedly re-cast it to keep the fire going longer. It can deal fire damage and ignite flammable materials in its area, so it definitely produces heat. However, it continues to burn even if no flammable materials are placed in its area. The spell has no material components. As long as you don’t intentionally place any flammable materials (or flammable creatures) in the bonfire’s space, this spell seems to satisfy all your requirements.

Create Bonfire might not work for a moving vehicle

Since you have added your reason for needing this spell, Create Bonfire may not be what you want. The bonfire created by the spell is stationary, but “stationary” is not clearly defined, leading to a number of questions about how certain spells work on moving vehicles, such as this one and this one. You should ask your DM how they will apply the rules in this case (or if you are the DM, you’ll need to make a ruling).

sql server – How to identify the top disk space consuming tables by file?

You may go to the report –> standard report and select Disk Usage by Top Table. This will be give you the table name in descending order which is used from maximum on disk to minimum on disk.

Alternatively, you may use the SQL below to get details:

SELECT sys.objects.name, SUM(reserved_page_count) * 8.0 / 1024 as Size
FROM sys.dm_db_partition_stats, sys.objects 
WHERE sys.dm_db_partition_stats.object_id = sys.objects.object_id 
GROUP BY sys.objects.name
ORDER BY Size DESC;
GO

Or this query:

SELECT TOP 1000
        a3.name AS SchemaName,
        a2.name AS TableName,
        a1.rows as Row_Count,
        (a1.reserved )* 8.0 / 1024 AS reserved_mb,
        a1.data * 8.0 / 1024 AS data_mb,
        (CASE WHEN (a1.used ) > a1.data THEN (a1.used ) - a1.data ELSE 0 END) * 8.0 / 1024 AS index_size_mb,
        (CASE WHEN (a1.reserved ) > a1.used THEN (a1.reserved ) - a1.used ELSE 0 END) * 8.0 / 1024 AS unused_mb

    FROM    (   SELECT
                ps.object_id,
                SUM ( CASE WHEN (ps.index_id < 2) THEN row_count    ELSE 0 END ) AS (rows),
                SUM (ps.reserved_page_count) AS reserved,
                SUM (CASE   WHEN (ps.index_id < 2) THEN (ps.in_row_data_page_count + ps.lob_used_page_count + ps.row_overflow_used_page_count)
                            ELSE (ps.lob_used_page_count + ps.row_overflow_used_page_count) END
                    ) AS data,
                SUM (ps.used_page_count) AS used
                FROM sys.dm_db_partition_stats ps
                GROUP BY ps.object_id
            ) AS a1

    INNER JOIN sys.all_objects a2  ON ( a1.object_id = a2.object_id )

    INNER JOIN sys.schemas a3 ON (a2.schema_id = a3.schema_id)

    WHERE a2.type <> N'S' and a2.type <> N'IT'   
    order by a1.data desc         

Note: I have not tested these queries myself, confirming back whether it works or not would be appreciated.

This has been asked on multiple forums and I have used answers from here.

As far as files are concerned, you may need to list filegroups, if none are defined, all the allocations will take place in primary filegroup.

Below query could help you finding physical location:

SELECT  OBJECT_NAME(i.id)   AS (Table_Name)
       , i.indid
       , i.(name)           AS (Index_Name)
       , i.groupid
       , f.name             AS (File_Group)
       , d.physical_name    AS (File_Name)
       , s.name             AS (Data_Space)
FROM        sys.sysindexes i
INNER JOIN  sys.filegroups f        ON  f.data_space_id = i.groupid 
                                    AND f.data_space_id = i.groupid
INNER JOIN  sys.database_files d    ON  f.data_space_id = d.data_space_id
INNER JOIN  sys.data_spaces s       ON  f.data_space_id = s.data_space_id
WHERE       OBJECTPROPERTY(i.id, 'IsUserTable') = 1
ORDER BY    f.name, OBJECT_NAME(i.id), groupid

Hope this helps.

sharepoint online – What is the payload to be sent for “ViewFields” parameter as part of consuming the SPO REST API?

I am trying to create a SharePoint list view through the SharePoint REST API, with a defined set of columns to be part of the view. The endpoint i am using is below:

POSTMAN API Request:

HTTP METHOD: POST

URL: https://tenantname.sharepoint.com/sites/SPSite/_api/web/lists/getbytitle(‘ListName’)/views Headers:

‘Accept’ – ‘application/json;odata=verbose’
‘Content-Type’ – ‘application/json;odata=verbose’
Body (JSON):

{
"__metadata":{
    "type":"SP.View"
},
"Title":"TestViewTHI",
"ViewQuery":("Name","Title")

}

I get a JSON error, since this payload does not seem to be right. Need help in understanding how to create a view with specific fields through the SharePoint REST API.

Thanks, Yesh

Time consuming callbacks in customizer

I am having a custom state ex. ‘visibility-state’ which having values as true | false.

I am binding this state to all the settings and settings are in 1000+ numbers. SO when the state changes it is recalling all the states 1000+ times which seems to be a heavy process.

    var setActiveState = function () {
    // This is calling 1000+ times.
                            element.active.set( logic_to_toggle() );
    };

    // This is in the loop of all the controls.
    api.state('visibility-state').bind( setActiveState );

Is there any optimized way to remove all bound functions and set only for the expanded sections so controls under the expanded section would toggle only?

Why is Wechat consuming a huge amount of storage

I am a very light wechat user, using it only for work to communicate with suppliers, yet my wechat constantly gets bloated, have had to clear it every month or so.

Below is an image with wechat consuming a large part of my internal storage.

Often people talk about the media taking most of the data, but this doesnt seem to add up with this image

wordpress – How do you know which plugin is consuming CPU?

My site is going down from time to time, I see in the server log that wp-load is requested a lot, I blocked external requests to this file. But I still get 5xx error once a day, I have a lot of plugins, my server settings are good. But how do I determine which plugin is causing this issue?

battery – Safari consuming a lot of juice on rMB 2016 with Mojave

I hope you’re all doing good and staying safe.

To make things short. I’ve upgraded to Mojave a month ago, since I couldn’t push ElCap for longer.
Until last month, my batt life was impeccable (I never let battery go below 60%, never overinflated it, etc etc).
I could get more than an hour without the full batt icon even showing a bit of usage.
So I can know for sure the batt is not the problem. Neither is the computer. I’ve used my computer on several 10+ hours and the battery life has always been exceptional.

I moved on to Mojave, and now my batt starts draining after less than 30 mins usage.

I knew this might happen, that’s why I sticked to ElCap.. but due to security reasons and app compatibility, I had to do the jump. Now I kinda regret it.

Thing is, only thing showing a hug Avg NRG impact is Safari.
I know some might say “it’s AVERAGE, not current”, yeah, but I have many other apps opened along with safari, and they don’t even get to a 10% of what Safari consumes in average.

Any ideas on how to get Safari behaving properly? Or any browser that avg impact doesn’t rise 300 and above?

I am also considering downgrading to ElCap, but would like to keep Mojave though.

Thanks in advance for any kind of input! 🙂

javascript – Consuming a rest API with react

I want to fetch a name and a photo from a rest API called “randomuserAPI”, to add to some kind of card in my website, but it just keeps fetching again and again in a loop, and never stops at one (I just want one random number and photo but it just keeps updating those things all the time).

This is my Course element, in which the card is created with the fetched data, which is fetched inside a function somewhere else.

import React, { useState } from 'react';
import '../App.css';
import {getUser} from '../library/getUsers.js'


const Course = ({author}) => { 

    const (userInfo, changeUserInfo) = useState('User')
    const (userPhoto, changeUserPhoto) = useState('https://i.stack.imgur.com/l60Hf.png')

    getUser(changeUserInfo, changeUserPhoto)

    return(
        <div className="course">
            <h4>{userInfo}</h4>
            <p>{author}</p>
            <img src={userPhoto} width="200px" height="200px" alt=""></img>
        </div>
    );
}

export default Course;

And this is the function which fetches the API:

export async function getUser(changeUserInfo, changeUserPhoto){

    await fetch('https://randomuser.me/api?results=3')
    .then(res => res.json())
    .then((user) => {
        changeUserInfo(`${user.results(0).name.first} ${user.results(0).name.first}`)
        changeUserPhoto(user.results(0).picture.large)
    })
}

I don´t know if anything can be wrong here, but here’s the App element:

import React from 'react';
import Course from './elements/course';
import './App.css';

function App() {
  return (
    <div className="app">
      <Course 
        author = 'Tato Gucci'
      />  
    </div>
  );
}

export default App;

rhel7 – Linux kernel process consuming 100% CPU

On my VM RHEL7, the kernel process migration/(some_number) CPU usage is 100% and continuously receives progressive lockout messages from the processor on the terminal.

PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
37 root      rt   0       0      0      0 R 100.0  0.0  10:26.94 migration/1
63 root      rt   0       0      0      0 R 100.0  0.0  10:16.72 migration/6

kernel:(2130030.151956) BUG: soft lockup - CPU#1 stuck for 23s! (migration/1:37)
kernel:(2130030.187921) BUG: soft lockup - CPU#4 stuck for 23s! (migration/4:53)

The system hangs after that and I have to restart it. This happens at least twice a month. I did some research on this problem and found that it was a bug in kernels before 3.6.11 and the workaround is to run the command # echo 0 > /proc/sys/kernel/sched_cpulimit_nr_balance. But my version of the VM kernel is much higher than that,

(root@jboss-iotapp-qa ~)# uname -a
Linux jboss-iotapp-qa 3.10.0-229.1.2.el7.x86_64 #1 SMP Fri Mar 6 17:12:08 EST 2015 x86_64 x86_64 x86_64 GNU/Linux

(root@jboss-iotapp-qa ~)# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)

I could not find the sched_cpulimit_nr_balance file,

(root@jboss-iotapp-qa ~)# ls -l /proc/sys/kernel/sched_cpulimit_nr_balance
ls: cannot access /proc/sys/kernel/sched_cpulimit_nr_balance: No such file or directory

Any suggestion would be appreciated.