How much does a “Potion of cure light wounds” heal?

According to the documentation, a potion of cure light wounds points to the spell “cure light wounds”. Now, the spell has some info about healing:

cures 1d8 points of damage +1 point per caster level (maximum +5)

But the caster level is just for the cleric who casts the spell. So what would be the correct amount of healing with the potion alone? just 1d8? or 1d8+5?

I could not find any clearer documentation for the potion yet.

How much damage does an Enlarged Huge Gray Ooze deal with their pseudopod?

The stat block for the Huge Gray Ooze indicates that on a hit its pseudopod deals:

6d6 acid damage plus 2d6 acid damage, or 12d6 acid damage while the ooze is enlarged.

Looking at the smaller gray ooze’s stat block, it seems that the additional 2d6 damage is possibly an error. Furthermore, the source material for the creature seems to indicate that the additional 2d6 is not intended either.

How much damage is the Huge Gray Ooze supposed to deal when it hits with their pseudopod? Is it effectively 8d6 acid or 6d6? What about when it uses the Enlarge feature on itself, which doubles the damage dice for the pseudopod?

Why is MEMORYCLERK_SQLGENERAL using so much memory in SQL Server?

I have a production system running SQL Server 2019 Standard edition. It recently had a problem 3 times in 1 day where it became unresponsive until a reboot. Errors seem to point to memory limitations. 32GB is installed and the machine is dedicated to MSSQL. Max Memory set to 26GB.

The best lead I have so far is output of dbcc memorystatus that was automatically dumped to the log along with a FAIL_PAGE_ALLOCATION error. The full output is attached, but this part below caught my eye. It looks like MEMORYCLERK_SQLGENERAL wanted so much memory that it forced normal things like the buffer pool and query memory down to uselessly small levels.

I can’t seem to find any good info on what MEMORYCLERK_SQLGENERAL does, let alone why it would want so much memory.

11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLGENERAL (node 0)                  KB Pages Allocated                            22821672 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                       546740 VM Committed                                  75776 VM Reserved                                12867644 ---------------------------------------- ---------- 11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLBUFFERPOOL (node 0)               KB Pages Allocated                                3400 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                            0 VM Committed                                      0 VM Reserved                                       0 ---------------------------------------- ---------- 11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQUERYPLAN (node 0)                KB Pages Allocated                                3632 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                            0 VM Committed                                      0 VM Reserved                                       0 ---------------------------------------- ---------- 11/18/2020 15:10:48,spid51,Unknown,MEMORYCLERK_SQLQUERYEXEC (node 0)                KB Pages Allocated                                1128 SM Committed                                      0 SM Reserved                                       0 Locked Pages Allocated                            0 VM Committed                                      0 VM Reserved                                       0 

Why metamagic feats for spell-like abilities that Warlocks use are so much stronger than regular metamagic feats at early levels?

Warlock is able to stack maximize and empower spell like abilities as early as level 6 without increasing effective caster level, which is not true for maximize/empower spell feat (for Sorcerers and Wizards)

Warlock is able to maximize and empower their magic items with that boost their eldritch blast such as gloves of eldritch admixture, which adds 4d6 to their total damage, but it doesn’t hold true for regular metamagic feats.

How come there is such a power gap between metamagic feats for spell vs spell like abilities?

SQL Server Nested views, how deep is too much?

I stumbled on a problem using views. The content management system my program interfaces with, defines a view which calls another view on the system. That is 2 levels to begin with. Before I stumble on views, I thought nested views were casual, but after my code blew up and i googled around, i begin to pick up words like "sin" and "vulgar" and "bad" which are associated with nested views.

Well I have two-level nested views to begin with. In my application level, I define my 3rd level and that’s when it gives me time out error. Is 3 level too much? The tables are not terribly big — between 5,000 and 100,000 records, while my view itself only produces 2,000 record. Is this suppose to break the camel’s back?

How much health will a Life Domain cleric regain from the Blessed Healer feature using the Mass Healing Word spell?

This question could loosely be considered a follow up to “Can Goodberries heal a Life cleric when consumed by another.”

How much life would a level 6 Life Cleric with four party members gain from the Blessed Healer class attribute with a casting of Mass Healing Word?

Blessed Healer

Beginning at 6th level, the healing spells you cast on others heal you as well. When you cast a spell of 1st level or higher that restores hit points to a creature other than you, you regain hit points equal to 2 + the spell’s level.

Mass Healing Word

As you call out words of restoration, up to six creatures of your choice that you can see within range regain hit points equal to 1d4 + your spellcasting ability modifier. This spell has no effect on undead or constructs.

If the Cleric casts Mass Healing Word, targeting each of the 4 party members, how many times would the Cleric gain HP equal to 2 + Spell Level?

Taken further, would the Blessed Healer effect be prevented if the Cleric targeted himself with Mass Healing Word, in addition to the other 4 members of his party?

How much damage does lava do?

How much damage does lava do?

On contact?

On submersion?

I know being in hot temperatures for long periods of time invokes levels of exhaustion. But the DM’s guide appears to neglect damage for lava, but it does specify damage for “falling” etc.

During the session last night I chose 10d6 for submersion for level 5 characters and that worked for the moment, but now I’m researching what the damage should have been.

How much does a house cost?

I’m running my players through the Lost Mines of Phandelver starter campaign and the fighter character with an aversion to low standard living arrangements is interested in buying a local home that she could be comfortable in on their downtime. I have searched through the Player’s Handbook and DM Guide and I cannot find anything about what kind of price range a simple house would cost. The closest I have found are some of the ships players could buy.

Am I missing something and one of the books has a starting point? Or is there perhaps something in the greater D&D materials I could use as a base guide?

Why Mathematica is not producing output and taking too much time

I’m trying to solve the given system of ODES but the Mathematica is taking too much time and not producing any output. I was trying to check the error by evaluating one one command but there was no error in any command but the equations EOM2, and EOM3 was taking too much time when I was trying to evaluate the equations.

For simple case aa=0, code works, but when I take non-zero aa, it takes a long time and didn’t produce output.

Can anyone please guide me how can I fix this problem? Is there any command in Mathematica that can be used to obtain the fast output?

 R2[r_, \[Theta]_] := r^2 + aa^2 Cos[\[Theta]]^2;  TR[r_, \[Theta]_] := r^2 - 2 M r + aa^2;   gtt[r_, \[Theta]_] := -(1 - (2 M r)/R2[r, \[Theta]]);  gt\[Phi][r_, \[Theta]_] := -(( 2 r M aa Sin[\[Theta]]^2)/    R2[r, \[Theta]]); g\[Phi]\[Phi][   r_, \[Theta]_] := (r^2 +      aa^2 + (2  M r (aa^2) )/       R2[r, \[Theta]] Sin[\[Theta]]^2) Sin[\[Theta]]^2;  grr[r_, \[Theta]_] := R2[r, \[Theta]]/TR[r, \[Theta]];  g\[Theta]\[Theta][r_, \[Theta]_] := R2[r, \[Theta]];   gUtt[r_, \[Theta]_] := -(1/    TR[r, \[Theta]]) (r^2 +      aa^2 + (2  M r (aa^2) )/ R2[r, \[Theta]] Sin[\[Theta]]^2);  gUt\[Phi][r_, \[Theta]_] := -((2 M aa r)/(   TR[r, \[Theta]] R2[r, \[Theta]]));  gU\[Phi]\[Phi][r_, \[Theta]_] := (  TR[r, \[Theta]] - aa^2 Sin[\[Theta]]^2)/(  TR[r, \[Theta]] R2[r, \[Theta]] Sin[\[Theta]]^2);  gUrr[r_, \[Theta]_] := TR[r, \[Theta]]/R2[r, \[Theta]];  gU\[Theta]\[Theta][r_, \[Theta]_] := 1/R2[r, \[Theta]]; M = 1; n = 4; glo = FullSimplify[{ {gtt[r, \[Theta]], 0, 0,       gt\[Phi][r, \[Theta]]}, {0, grr[r, \[Theta]], 0, 0}, {0, 0,       g\[Theta]\[Theta][r, \[Theta]], 0}, {gt\[Phi][r, \[Theta]], 0, 0,       g\[Phi]\[Phi][r, \[Theta]]}}]; gup = FullSimplify[{ {gUtt[r, \[Theta]], 0, 0,       gUt\[Phi][r, \[Theta]]}, {0, gUrr[r, \[Theta]], 0, 0}, {0, 0,       gU\[Theta]\[Theta][r, \[Theta]], 0}, {gUt\[Phi][r, \[Theta]], 0,       0, gU\[Phi]\[Phi][r, \[Theta]]}}];   dglo = Simplify[Det[glo]];  crd = {t, r, \[Theta], \[Phi]};  Xup = {t[\[Tau]], r[\[Tau]], \[Theta][\[Tau]], \[Phi][\[Tau]]}; Vup = {Vt, Vr, V\[Theta], V\[Phi]}; Pup = {Pt[\[Tau]], Pr[\[Tau]], P\[Theta][\[Tau]], P\[Phi][\[Tau]]};  Sup = {{Stt[\[Tau]], Str[\[Tau]], St\[Theta][\[Tau]],      St\[Phi][\[Tau]]},     {Srt[\[Tau]], Srr[\[Tau]], Sr\[Theta][\[Tau]], Sr\[Phi][\[Tau]]},    {S\[Theta]t[\[Tau]], S\[Theta]r[\[Tau]], S\[Theta]\[Theta][\[Tau]],      S\[Theta]\[Phi][\[Tau]]},    {S\[Phi]t[\[Tau]], S\[Phi]r[\[Tau]], S\[Phi]\[Theta][\[Tau]],      S\[Phi]\[Phi][\[Tau]]}};   christoffel =    Table[(1/2)*     Sum[(gup[[i, s]])*(D[glo[[s, k]], crd[[j]] ] +          D[glo[[s, j]], crd[[k]] ] - D[glo[[j, k]], crd[[s]] ]), {s, 1,        n}], {i, 1, n}, {j, 1, n}, {k, 1, n}] ;   riemann =   Table[ D[christoffel[[i, j, l]], crd[[k]] ] -      D[christoffel[[i, j, k]], crd[[l]] ] +      Sum[christoffel[[s, j, l]] christoffel[[i, k, s]] -        christoffel[[s, j, k]] christoffel[[i, l, s]],      {s, 1, n}], {i, 1, n}, {j, 1, n}, {k, 1, n}, {l, 1, n}] ;   loriemann =    Table[Sum[glo[[i, m]]*riemann[[m, j, k, l]], {m, 1, n}], {i, 1,      n}, {j, 1, n}, {k, 1, n}, {l, 1, n}] ;   EOM1 = Table[ D[Xup[[a]], \[Tau]] == Vup[[a]] , {a, 1, n}];    EOM2 = Table[     D[Pup[[a]], \[Tau]] + \!\( \*UnderoverscriptBox[\(\[Sum]\), \(b = 1\), \(n\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(c =           1\), \(n\)]christoffel[\([\)\(a, b, c\)\(]\)]*         Pup[\([\)\(b\)\(]\)]*Vup[\([\)\(c\)\(]\)]\)\) == -(1/2) \!\( \*UnderoverscriptBox[\(\[Sum]\), \(b = 1\), \(n\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(c = 1\), \(n\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(d = 1\), \(n\)]riemann[\([\)\(a,            b, c, d\)\(]\)]*Vup[\([\)\(b\)\(]\)]*          Sup[\([\)\(c, d\)\(]\)]\)\)\),    {a, 1, n}];  EOM3 = Table[     D[Sup[[a, b]], \[Tau]] + \!\( \*UnderoverscriptBox[\(\[Sum]\), \(c = 1\), \(n\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(d =           1\), \(n\)]christoffel[\([\)\(a, c, d\)\(]\)]*         Sup[\([\)\(c, b\)\(]\)]*Vup[\([\)\(d\)\(]\)]\)\) + \!\( \*UnderoverscriptBox[\(\[Sum]\), \(c = 1\), \(n\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(d =           1\), \(n\)]christoffel[\([\)\(b, c, d\)\(]\)]*         Sup[\([\)\(a, c\)\(]\)]*Vup[\([\)\(d\)\(]\)]\)\) ==      Pup[[a]]*Vup[[b]] - Pup[[b]]*Vup[[a]],    {a, 1, n}, {b, 1, n}];    Wfactor = 4*\[Mu]^2 + \!\( \*UnderoverscriptBox[\(\[Sum]\), \(i = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(j = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(k = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(l =           1\), \(4\)]\((loriemann[\([\)\(i, j, k,            l\)\(]\)]*\((Sup[\([\)\(i, j\)\(]\)])\)*\ \((Sup[\([\)\(k,             l\)\(]\)])\))\)\)\)\)\);  Wvec = Table[2/(\[Mu]*Wfactor)*(\!\( \*UnderoverscriptBox[\(\[Sum]\), \(i = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(k = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(m = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(l = 1\), \(4\)]Sup[\([\)\(j,             i\)\(]\)]*           Pup[\([\)\(k\)\(]\)]*\((loriemann[\([\)\(i, k, l,              m\)\(]\)])\)*\((Sup[\([\)\(l, m\)\(]\)])\)\)\)\)\)), {j,      1, n}];   NN = 1/Sqrt[1 - \!\( \*UnderoverscriptBox[\(\[Sum]\), \(i = 1\), \(4\)]\( \*UnderoverscriptBox[\(\[Sum]\), \(k =         1\), \(4\)]\((glo[\([\)\(i, k\)\(]\)])\)*Wvec[\([\)\(i\)\(]\)]*       Wvec[\([\)\(k\)\(]\)]\)\)];   {Vt, Vr, V\[Theta], V\[Phi]} = NN (Wvec + Pup);  EOM = Flatten[    Join[{EOM1, EOM2, EOM3} /.          r -> r[\[Tau]] /. \[Theta] -> \[Theta][\[Tau]] /.        Derivative[1][r[\[Tau]]][\[Tau]] -> Derivative[1][r][\[Tau]] /.       Derivative[1][\[Theta][\[Tau]]][\[Tau]] ->        Derivative[1][\[Theta]][\[Tau]]]];  INT1 = {t[0] == 0,     r[0] == r0, \[Theta][0] == \[Theta]0, \[Phi][0] == 0}; INT2 = {Pt[0] == 1.32288, Pr[0] == 0, P\[Theta][0] == 0,     P\[Phi][0] == 0.07143}; INT3 = {{Stt[0] == 0, Str[0] == 0, St\[Theta][0] == 0,      St\[Phi][0] == 0},     {Srt[0] == 0, Srr[0] == 0, Sr\[Theta][0] == 0, Sr\[Phi][0] == 0},    {S\[Theta]t[0] == 0, S\[Theta]r[0] == 0, S\[Theta]\[Theta][0] == 0,      S\[Theta]\[Phi][0] == 0},    {S\[Phi]t[0] == 0, S\[Phi]r[0] == 0, S\[Phi]\[Theta][0] == 0,      S\[Phi]\[Phi][0] == 0}}; INT = Flatten[Join[{INT1, INT2, INT3}]]; r0 = 7; \[Theta]0 = Pi/2; \[Mu] = 1; aa = 0.5; M = 1;  NDSolve[Flatten[Join[{EOM, INT}]], {t, r, \[Theta], \[Phi], Pt, Pr,    P\[Theta], P\[Phi], Stt, Str, St\[Theta], St\[Phi], Srt, Srr,    Sr\[Theta], Sr\[Phi],   S\[Theta]t, S\[Theta]r, S\[Theta]\[Theta], S\[Theta]\[Phi],    S\[Phi]t, S\[Phi]r, S\[Phi]\[Theta], S\[Phi]\[Phi]}, {\[Tau], 0,    1000}] 

One PC doing too much damage

I just took over as DM for our group. The previous DM allowed our ranger to purchase a significant amount of Wyvern poison at the end of the last adventure to dip his arrows in. With this poison, the ranger is doing 7d6 poison damage when he hits.

Our characters are all level 5 and 6 so this is obviously a significant amount of damage for this level. I’m worried by simply upping the AC of NPCs, no one else will be able to hit. It feels a little cheap to give the majority of NPCs poison resistance.

Any tips on how to combat this issue?

What I’m considering: Our barbarian has an evil, sentient sword. My thought was while the group is traveling and asleep, the evil sword has become jealous of the amount of damage the range is dealing so the sword mind controls the barbarian to get up and dump most of the poison out the back of the caravan they’ll be traveling in.

Is this too brutal to do to the ranger??