Waiting time for the SQL Server query with the NOT IN clause but IN is working correctly

So we used SQL Server 2016 Enterprise and suddenly have a problem with a request on the production server.

Works well on Test and Dev and if we also save and restore the production database on one of these jobs as well.

Fundamentally,

SELECT * FROM ExchangeRatesSettlement WHERE RateTypeKey NOT IN (3,4,5,6)

the time is up after an hour, it worked well for more than 6 months.

Take about 10 seconds on the backup test.

If I rewrite the query to be

SELECT *
FROM ExchangeRatesSettlement
WHERE RateTypeKey IN (SELECT RateTypeKey
from RateTypes
WHERE RateTypeKey NOT IN (3,4,5,6)

so it's an IN of a NOT IN subquery it goes back to 10 seconds.

I am completely perplexed.

Some time ago, we had something similar on this machine, where a query with a CTE started to expire, but if we collided the CTE in the FROM in parentheses, everything would run smoothly.

html – When working with css animations, is there a way to do a repetition of successive animations to infinity in the given order

when I was working with CSS animations, I had to do two successive animations, but as soon as I did, I had just reminded myself that the animations had to be repeated indefinitely, is there a way to make them repeat themselves indefinitely in the same order
without doing the animations one by merging keyframes, using only CSS, if there is none, how to do it with javascript?

Stop using an app during working hours

I must avoid using a personal email application on my Android phone during working hours.
One solution is to uninstall the application before the start of work and to install it again after hour of work.
Or use application blockers?
Or … what else?

Unity3d: keep working on the project in the editor while building for android from the command line

Is it possible to continue working on the project in the editor while it is built for android from the command line?

unit – Quaternion.RotateTowards not working as expected when the parent object is moved / rotated

I have a tank with a rigid body. A turret base is attached to the tank via a hinged joint. The bottom TourelleContr├┤leur The script is attached to the base of the turret to rotate it to point to the mouse.

The turret turns perfectly when the tank is stationary. But once I start moving, the rotation behavior becomes very erratic: https://youtu.be/v1VuTbMtcCM

If someone can help / explain this behavior, it would be very appreciated!

/// 
/// Turn a turret to a point at a fixed angular velocity.
/// 
Public category TurretController: MonoBehaviour
{
floating public m_DegreesPerSecond = 40f;

private Vector3 m_TargetPosition;

// Received a mouse move event
public void Rotate (PointInputInfo inputInfo)
{
m_TargetPosition = inputInfo.Point;
}

RotateTurret () empty private
{
Vector3 direction = Vector3.Scale (m_TargetPosition - transform.position, new vector3 (1, 0, 1));
Quaternion targetRotation = Quaternion.LookRotation (direction, Vector3.up);
Debug.DrawLine (transform.position, m_TargetPosition);

// Rotate at a fixed angular speed.
transform.rotation = Quaternion.RotateTowards (transform.rotation, targetRotation, Time.deltaTime * m_DegreesPerSecond);
}

Private void FixedUpdate ()
{
RotateTurret ();
}
}

wireless flash – Is the transmitter Yongnuo 622C TX working with Neewer Vision 5?

Does the transmitter Yongnuo 622C TX work with Neewer Vision 5?

I have a Canon MarkDIII, a Canon Flash 580 EX ii, multiple YN 568 EXII flashes, multiple YN622C receivers and 2 transmitters TX YN622C; I am looking to buy the Neewer Vision 5 manufactured by Visico (their 400w monolight outdoor portable stroboscope). I want to use the trigger provided with the Vision 5 strobe connected to my camera to control everything and work in ETTL mode with the strobe AND to work with my YN receivers on the YN flashing all in ETTL mode or in other modes , OR I want to use my YN 622C TX transmitter to work with the Vision 5 strobe and control everything on the camera.

Or, if nothing works, will the Canon ST-E3-RT work with the Vision 5 Strobe in ETTL mode and other modes, as well as with my YN Flashs and YN 622C receivers?

In other words, I just want to use the trigger that works on my camera, either the transmitter YN 622C TX, or the trigger Neewer Vision 5 (818x), or the trigger Canon ST-E3-RT to control the Neewer Vision portable flash and my other flashes that are connected to receivers, all at the same time from the location of my camera, is it possible, compatibility issues can be a problem? Thank you.

seo – AMP URL not found (404) in Google Webmaster Tools but AMP / Canonical pages are working properly

Google Webmaster Tools has reported 404 errors for a number of my AMP pages since last month. The number of pages affected changes every 24 hours and now rises every day, which kills my mobile traffic.

Test Live URL: Works correctly on every page reported, successful page extraction, allowed indexing, valid linked AMP version.

The canonical link works, the AMP link works, the Smartphone bot is the only one that seems to be confused.

View post on imgur.com

Any help to find a solution would be greatly appreciated, because at the moment, my web traffic is dying of these problems quickly. Here are some URLs reported …

https://letsprint3d.net/2018/10/04/install-micro-swiss-all-metal-hotend-ender-3/amp/
https://letsprint3d.net/2018/07/31/guide-how-to-setup-auto-bed-leveling-ender-3/amp/
https://letsprint3d.net/2018/05/21/how-to-make-money-with-3d-printers/amp/

Ubuntu 19.04 stops working – Ask Ubuntu

I am facing a strange problem with my laptop, running Ubuntu 19.04. Since today morning, suddenly, my laptop stops working after a series of symptoms such as an increase in brightness to the maximum (I prefer working with a low brightness), then the keyboard of the laptop. Laptop stops working. I am able to move the cursor on the screen but the click does not work). To get rid of this, I use to remove the battery and restart the laptop again.
I do not understand why this is happening. Is there a problem with the hardware of a laptop or a problem with Ubuntu? I am in serious need of help as this happens every 2-3 hours now. Thank you.

node.js – Run dependencies with NPM not working

I just returned to Web Development and already had Node.js installed on my computer. I was trying to run npm install -g live-server work with the live server of npm.

That's what was rendered when I ran npm install -g live-server.

ashle @ DESKTOP-PFHHR2C MINGW64 ~ / Desktop / npmtest
$ npm install -g live-server
npm WARN obsolete opn@6.0.0: the package has been renamed to `open`
C:  Users  ashle  AppData  Roaming  npm  live server -> C:  Users  ashle  AppData  Roaming  npm  node_package  live-server  live-server.js
npm optional WARN OPTIONAL SKIPPING DEPENDENCY: fsevents@1.2.9 (node_modules  live-server  node_modules  fsevents):
npm WARN notsup OPTIONAL SKIPPING DEPENDENCE: Platform not supported for fsevents@1.2.9: wanted {"os": "darwin", "arch": "all"} (current: {"os": "win32 "," arch ":" x64 "})

+ live-server@1.2.1
added 191 packs of 149 backers in 22,221s

The installation seemed to work well; however, when I ran live server I had the following error:

ashle @ DESKTOP-PFHHR2C MINGW64 ~ / Desktop / npmtest
$ live-server
Service "C:  Users  ashle  Desktop  npmtest" at the address http://127.0.0.1:8080
events.js: 174
launch er; // event & # 39; error & # 39; not managed
^

Error: spawn cmd ENOENT
on Process.ChildProcess._handle.onexit (internal / child_process.js: 240: 19)
at onErrorNT (internal / child_process.js: 415: 16)
at process._tickCallback (internal / process / next_tick.js: 63: 19)
on Function.Module.runMain (internal / modules / cjs / loader.js: 832: 11)
at startup (internal / bootstrap / node.js: 283: 19)
on bootstrapNodeJSCore (internal / bootstrap / node.js: 622: 3)
Event & # 39; error & # 39; issued to:
on Process.ChildProcess._handle.onexit (internal / child_process.js: 246: 12)
at onErrorNT (internal / child_process.js: 415: 16)
    [... lines matching original stack trace ...]
    on bootstrapNodeJSCore (internal / bootstrap / node.js: 622: 3)

I've already tried to completely remove Node.js from Windows using this (https://stackoverflow.com/questions/20711240/how-to-completely-remove-node-js-from-windows); However, once I installed the node and the live server again, it always returned the same error.

I checked the PATH to make sure that C: Users Webmaster AppData Roaming npm was present. Maybe something went wrong while I accidentally deleted all other environment variables or maybe I'm completely unaware of something that I'm doing wrong? Has anyone else encountered this problem?

Edit: I've also tried installing gulp. These packages were installed then, when I tried to run it, the same message appeared, so I do not think this is a problem exclusive to the active server.

Can I immigrate to the United States while working remotely for a company based in Australia?

I am currently working remotely for an Australian company and I live in Australia. In the future, I would like to immigrate permanently to the United States to live with my girlfriend, an American citizen. My employer allowed me to continue working remotely for the Australian American company.

I am not sure of being eligible for a visa for a job or business because I will not be employed by a US company. If possible, I would like to avoid consecutive traveler visas that require me to return periodically to Australia on their expiration date.

I am willing to apply for a K-1 fiancee visa and to marry my girlfriend within 90 days of my arrival in the United States, but I would like to know what other options suit me.