Updating column value across all SQL server versions

I have a simple table with 3 columns

Installed by – some login name

Installed date – Date when bunch of scripts were run with any changes as part of that package

Version – version number when release was done

I am thinking below.

UPDATE Tablename SET Version = '7.8.1' ; 

In case above is not the correct way, How should I correctly update the version # column when release is done say when some scripts are installed today, version # needs to be updated lets say 7.8.1. Also this needs to work across all versions of SQL server from 2012 to 2019

Table scan instead of index seeks happening when where clause filters across multiple tables in join using OR

We have an application generated query using a view that has two tables joined on a LEFT OUTER join. When filtering by fields from just one table (either table) an index seek happens and it’s reasonably fast. When the where clause includes conditions for fields from both tables using an OR the query plan switches to a table scan and doesn’t utilize any of the indexes.

All four fields that are being filtered on are indexed on their respective tables.

Fast query plan where I filter on 3 fields from one table: https://www.brentozar.com/pastetheplan/?id=Hym_4PRSO

Slow query plan where I filter on four fields…three from one table and one from another table: https://www.brentozar.com/pastetheplan/?id=r1dVNDRHO

Ideally I would like to understand why this is happening and how to nudge the query engine to utilize all the indexes.

What are the patterns to spell distribution across classes?


It is obvious that there are patterns to spell distribution across classes.

For instance, typically only druids and rangers have access to nature-themed spells. As another example, healing spells tend toward cleric and away from wizard, if that makes sense.

There are some surprises. For instance, Cure Wounds is available to bard, cleric, druid, paladin, and ranger; whereas Healing Word is available to only bard, cleric, and druid.

Another somewhat surprising example: Find Familiar is only available to wizard. Why is that? Certainly the general tropes of fantasy don’t suggest clerics would have familiars, but what about sorcerers and warlocks?

Clearly there are patterns. In the case of Cure Wounds and Healing Word, the pattern could be that only full casters get to heal at a distance; or, perhaps healing by touch is more thematically appropriate for paladins and rangers.

The Question

Is there any published official material stating, as the title says, What the patterns are to spell distribution across classes?

Failing published official material, is there any published unofficial material on the question, or any third party analysis?

I’m not looking for answers about my specific examples, but about the overall picture.

I’ve looked through the published materials, the internet generally, and particularly here on rpg, and haven’t found anything, but maybe I’m just not looking in the right place.

mapping a digraph across sectors of countries

Given a (9,9) matrix representing three countries (for example, the US, China, Russia), each one of which has three sectors (vertices/sectors {1, 2, 3) for the US; {4, 5, 6} for China; and {7,8,9} for Russia), I like to create a map of the directed linkages between all 9 sectors using the actual world map.

SeedRandom[01]; g={{1.09738, 0.0440055, 0.113012, 0.0436654, 0.0550311, 0.0365684,   0.0990232, 0.0550859, 0.0629618}, {0.0850364, 1.05189, 0.0803699,   0.0999457, 0.0846171, 0.115742, 0.078153, 0.111992,   0.0828957}, {0.0982489, 0.0712597, 1.07401, 0.0723417, 0.0431498,   0.0824737, 0.126777, 0.0569532, 0.0808742}, {0.089248, 0.114673,   0.135009, 1.10033, 0.0743107, 0.107282, 0.133689, 0.0850109,   0.0467125}, {0.0921911, 0.0582554, 0.0937256, 0.0535134, 1.10261,   0.0882558, 0.0366383, 0.154662, 0.0893078}, {0.0835567, 0.0541454,   0.0971447, 0.0458107, 0.132431, 1.08961, 0.0726788, 0.108789,   0.118664}, {0.0747554, 0.150188, 0.139565, 0.0936757, 0.132907,   0.140158, 1.05936, 0.0964287, 0.116732}, {0.0667764, 0.0489254,   0.137437, 0.0962666, 0.0882702, 0.0704283, 0.0807027, 1.05768,   0.101375}, {0.0824603, 0.11258, 0.135069, 0.110204, 0.102288,   0.103722, 0.0453945, 0.0473116, 1.10549}}; n = 9; d = 0.12; G = RandomGraph[{Round[n], Round[n*(n - 1)*d]}, DirectedEdges ->True]; Ga = AdjacencyMatrix[G]*g; sa = SparseArray[Ga]; weightedG =    Graph[sa["NonzeroPositions"], EdgeWeight -> sa["NonzeroValues"],    DirectedEdges -> True, VertexCapacity -> {i_ :> i},    VertexSize -> .3]; SetProperty[weightedG,    VertexLabels -> {i_ :>    Placed[PropertyValue[{weightedG, i}, VertexCapacity], Center]}] 

Split data across multiple rows in a single statement

I have data in table like

Customer Invoice No Date Value Paid Balance
ABC 1 01/12/2020 25 0 25
ABC 2 01/12/2020 50 0 50
XYZ 3 02/12/2020 200 0 200
XYZ 4 04/12/2020 100 0 100
ABC 5 04/12/2020 500 0 500

Now I received amounts for customers as below

ABC 540 XYZ 210

540 210

After receiving the amounts my table should like this

Customer Invoice No Date Value Paid Balance
ABC 1 01/12/2020 25 25 0
ABC 2 01/12/2020 50 50 0
XYZ 3 02/12/2020 200 200 0
XYZ 4 04/12/2020 100 10 90
ABC 5 04/12/2020 500 465 35

I got some clues but this works only for date based values but I need customer and date based.

Any help will be appreciated

When using Magic Jar, what effects follow the user across bodies?

There’s a similar question for 3.5e where the answer is ‘unanswered’, but I’m hoping there’s something in 5e that’s different.

To set an example scene: You’re a Draconic Bloodline Sorcerer with Draconic Resilience. You’re also a Bladesinging Wizard, and you’ve activated Bladesong. You have two attuned items. You’ve cast Haste and Invisibility on yourself. The Bard has given you inspiration. You’ve been frightened by an enemy, but you’ve charmed them back. You proceed to use Magic Jar on a random goblin.

What is carried over? What if you did all that as the goblin, then returned to your own body? Do the effects affect the body, or the ‘soul’?

Sync logins and Agent jobs across all replicas in Distributed Availability Group

I am using dba_CopyLogins stored proc to sync logins on replicas in Distributed Availability group , but the database level permissions are not transferred due to database sync operation is going on.. Is there any way to sync all logins and permissions from global primary to Forwarder and other replicas? also how to copy agent jobs?

facetwp leave all filters active across all pages, archives or single post

I will be quick and precise, I created a real estate site, I used the facetwp solution not very difficult to understand and with a rich documentation and hooks. I think I have everything in front of me but I need some help to understand which one. I’m still learning.

I put the links at the bottom.

the problem I can’t figure out which hook to use to basically tell facetwp to leave all filters active across all pages, archives or single post of properties , ignore post category, taxonomies, etc..do not auto-detect filters ,the header filters must remain the same everywhere

I have attached an illustration


How to Customize WordPress Archive Queries

80 hooks available wich one i can use ?

they talk about that too :" Instead of creating an entirely separate query, we recommend using WP’s pre_get_posts filter to modify the existing query."

update 26/10/2020

I updated the image to illustrate the problem.

I still haven’t figured out what to do.. I hope it’s clear and at least someone understands the problem.

enter image description here