how to delete specific range of data from system queue data table?

due to sudden increase of my database .mdf file we check there are 4 internal queue message table are increase unexpectedly. so we decided to delete some range of data from these table.

we try this code:

declare @c uniqueidentifier while(1=1) begin     select top 1 @c = conversation_handle from dbo.queuename     if (@@ROWCOUNT = 0)     break     end conversation @c with cleanup end   

but its try to delete all data and due to space limitation the query cannot execute. my internal message queue table :

enter image description here

enter image description here

Does the bonus action shove from Unearthed Arcana’s Telekinetic feat move the target through the air, or only on the ground?

Imagine a party of PCs exploring a dungeon inside a volcano. After a climactic confrontation with the Big Bad, the volcano begins to erupt, and the PCs must flee for their lives. Unfortunately, one of the PCs — Tarly Target — is badly injured and can barely walk. Working together to carry Target, the PCs race toward the volcano’s mouth. Just as freedom nears, a sudden quake tears open the path before them, creating a 15-foot chasm that begins filling with molten lava. There’s no way Target can make the jump.

Psimon Psion, a PC with the Telekinetic feat from Unearthed Arcana’s "Psionic Options Revisited", proposes to use the feat to try to hurl Target across the chasm. The feat’s third bullet says:

As a bonus action, you can try to telekinetically shove one creature you can see within 30 feet of you. When you do so, roll your Psionic Talent die, and the target must succeed on a Strength saving throw (DC 8 + your proficiency bonus + the ability modifier of the score increased by this feat) or be moved toward you or away from you a number of feet equal to 5 times the number you rolled. A creature can willingly fail this save.

Assuming Psion could roll a 3 or greater on his Psionic Talent Die, sufficient to move Target the full 15 feet required to clear the chasm, is this a viable use of the feat? Must Target remain in contact with the ground the entire time he’s being moved by the shove, such that he’d immediately plunge to his doom once moved over the chasm? Or can the shove actually propel him through the air to the other side?

For completeness’s sake, I note the following:

  • The normal shove action (PHB p. 195-196) only moves a creature a maximum of 5 feet, so it does not offer much guidance here.
  • The telekinesis spell (PHB p. 280-281) can move a creature, but the move is not characterized as a shove and explicitly can hold the target in mid-air, so it is not helpful here either.

Does the disadvantage on saves from Shadow Sorcerer’s Hound of Ill Omen feature persist beyond the first turn?

Shadow Sorcerer’s Hound of Ill Omen feature’s text reads:

…Additionally, while the hound is within 5 feet of the target, the target has disadvantage on saving throws against any spell you cast. The hound disappears if it is reduced to 0 hit points, if its target is reduced to 0 hit points, or after 5 minutes.

I’m curious if against any spell you cast refers to the action of casting the spell, or the condition of having been a spell that you cast in any tense.

The difference being that a spell like Hold Person would only get disadvantage on the first saving throw with the first interpretation, but on all following saving throws with the second interpretation.

The only comparable feature that I know of is Heightened Spell, a Sorcerer metamagic, that reads:

When you cast a spell that forces a creature to make a saving throw to resist its effects, you can spend 3 sorcery points to give one target of the spell disadvantage on its first saving throw made against the spell.

This feature is clear in its intent, that only the initial saving throw against any spell is affected and given disadvantage.

The lack of clarification on Hound of Ill Omen makes me wary of which way to rule.

Four 301-redirects from ‘www.myproject.com’ to ‘shop.myproject.com’ (am I losing my Google PageRank?)

Some years ago, I started my website with the main domain ‘www.myproject.com’. However, the project ended up being a store under ‘shop.myproject.com’.

I obtained hundreds of links to ‘http://www.myproject.com’, and today (after two years) I found that the redirection is not well-constructed, because there are four 301-redirects from ‘http://www.myproject.com’ to ‘https://shop.myproject.com’.

I have two questions:

  1. Should I fix urgently this issue of "too many 301-redirects" in order not to loose my Google PageRank?
  2. Is there any quick Rewrite Rule for Apache 301-redirect from ‘http://www.myproject.com’ to ‘https://shop.myproject.com’?

Replacing $x,y$ in $f(x,y,z)$ with values from a list

I’m sure there is a simple solution to this using map or apply, but its not occurring to me.

Suppose I have a function $ f(x,y,z)= x+y+z)$

And I want to evaluate $ f(x,y,1)$ for $ \{x,y\} ∈ \{\{1,2\},\{3,4\}\}$

What is the best way to do this?


Examples:

If I use f[x_,y_,z_]:= x+y+z; f[#1,#2,1]&/@ {{1,2},{3,4}}

this will give me things like {{2+#2,3+#2}}.

On the other hand, Apply works on a single element f[#1,#2,1]& @@ {1,2} but not on a list such as {{1,2},{3,4}}. On the list it gives me {f[1,3,1],f[2,4,1]

I am not sure how to go from the case of a single pair to a list of pairs

Can spells that stabilize you when you would die protect you from death by massive damage?

Characters die from damage when their health is reduced below their negative Constitution score. However, some spells stabilize you when you would die. Can these spells save you from the massive damage rule?

For example, Shadow Endurance says:

If you are reduced below 0 hit points or rendered unconscious, shadow endurance immediately discharges, shunting your injured body into a hidden alcove on the Shadow Plane.

You immediately stabilize, but cannot awaken or take any further actions until the second duration expires.

Nine Lives does something similar:

Rejuvenate: The target uses this ability when it is reduced to 0 or fewer hit points. The target is instantly healed 3d6 points of damage. If enough hit points are regained to bring the target to positive hit points, it does not fall unconscious. If it is not enough to leave the target with positive hit points, the target automatically stabilizes. Both of these effects work even if the damage was originally enough to kill the target.

Can spells that stabilise you when you’d die overrule death from massive damage?

Characters can die from massive damage when their health is reduced below their negative endurance score. However, some spells stabilise you when you’d die. Can these spells stabilise you even from massive damage?

For example, Shadow Endurance says:

If you are reduced below 0 hit points or rendered unconscious, shadow endurance immediately discharges, shunting your injured body into a hidden alcove on the Shadow Plane.

You immediately stabilize, but cannot awaken or take any further actions until the second duration expires.

Nine Lives does similar:

Rejuvenate: The target uses this ability when it is reduced to 0 or fewer hit points. The target is instantly healed 3d6 points of damage. If enough hit points are regained to bring the target to positive hit points, it does not fall unconscious. If it is not enough to leave the target with positive hit points, the target automatically stabilizes. Both of these effects work even if the damage was originally enough to kill the target.

I feel it’s made fairly clear in the case of nine-lives that you wouldn’t die, but it’s less clear for me whether it’d work the same way in the case of Shadow Endurance. How spells that stabilise you from death interact with death from massive damage? Can they successfully stabilise you, or do you die anyway?

Can an artificer cast spells using a single component from a set of artisan’s tools?

Under Tools Required

You produce your artificer spell effects through your tools. You must have a spellcasting focus – specifically tinker’ tools or some kind of artisan’s tool – in hand when you cast any spell with this Spellcasting feature. You must be proficient with the tool to use it in this way.

"Artisan’s tool" is singular. But it can refer to a set of objects.

For example:

Weaver’s tools include thread, needles, and scraps of cloth.

Weaver’s tools are an artisan’s tool but does an artificer proficient with them need to hold the needle, thread, and cloth in one hand to cast spells?

For example, the party has been striped of all their belongings but not their clothes. Can an artificer with proficiency in weaver’s tools tear off a scrap of their clothing and begin casting?