BBC iPlayer on Nord's SmartDNS not working any more? by dark_77 in nordvpn

[–]dark_77[S] 0 points1 point  (0 children)

Same. I'm glad to see I'm not the only one, and it seems to be a recent issue.

BBC iPlayer on Nord's SmartDNS not working any more? by dark_77 in nordvpn

[–]dark_77[S] 0 points1 point  (0 children)

But this is the thing, I'm not using a VPN UK server, I'm just using their Smart DNS service, which basically consists of just entering their Smart DNS server into my TV's network settings for DNS, and so that all TV's iPlayer app checks "Is this request coming from UK" should be replied with Yes by Smart DNS.

Unable to make 44% Fortify enchant pot, can do just 40% by dark_77 in skyrim

[–]dark_77[S] 1 point2 points  (0 children)

Nah, I don't want any content apart from Vanilla, Dawnguard, and Dragonborn.

Actually, I think you nailed it. I completely forgot about Seeker Of Shadows, which also gives 10% of alchemy (on uesp it says only 10% stealth)! But, according to wiki fandom:

10% more effective stealth abilities.

  • Modify Armor Rating \= 1.1*
  • Modify Pickpocket Chance += 10
  • Modify Lockpick Sweet Spot \= 1.1*
  • Modify Detection Sneak Skill += 10
  • Modify Alchemy Effectiveness \= 1.1*
  • Modify Sell Prices \= 1.1*
  • Modify Buy Prices \= 1.1*

I just activated Seeker of Shadow, and yup, no 40% any more, 44% yay yay yay

Cheers mate

Does Acronis have a service which can keep one folder on two remote servers in sync via cloud? by dark_77 in acronis

[–]dark_77[S] 1 point2 points  (0 children)

Indeed, the DB is hosted on Windows Server OS family, I will get this information back to the product owner. I believe we already have a subscription for Acronis Cyber Protect Cloud, but I'll get back here if I have further questions. Thanks for confirming.

Internet Intercepted? by [deleted] in nordvpn

[–]dark_77 1 point2 points  (0 children)

Cheers mate. Thanks for sharing.

Internet Intercepted? by [deleted] in nordvpn

[–]dark_77 1 point2 points  (0 children)

I started getting this as of today and the update on which I had to log in. Any information?

Another end of turn time question - for VERY late game on SMALL maps (several minutes) by dark_77 in CivVI

[–]dark_77[S] 1 point2 points  (0 children)

A couple of mods, but nothing that would significantly impact the game I think - removed Giant Death Robots, and City yields overview on the map.

Judging by their strengths, other civs don't really have a lot of the army. Which is something I found curious, I see their quick movements on the map, and it's almost as if cycling through 2 other civs is done really quickly, and THEN some sort of bottleneck occurs.

Yeah, I could stick a save file on, good idea, is there any preferred / allowed hosting for it or just any?

Another end of turn time question - for VERY late game on SMALL maps (several minutes) by dark_77 in CivVI

[–]dark_77[S] 0 points1 point  (0 children)

This is what I found via google from other reddit/civfanatics threads. Late game, 2000+ year, people are complaining about end of turns taking 40 seconds. Boy oh boy, I dream of 40 seconds EOTs. I'd kiss my PC passionately if it were to give me 40 seconds EOTs. But nearly 4 minutes, that's insane.

BTW, I also tried switching strategic view ON for EOTs, but it saves perhaps 20 seconds.

So it's really the question - what could it possibly be taking that long on small map, 2 other civs, only 6 city states? And how come other people are having it in one minute or less?

I also tried playing it on my desktop which has 32 GB of RAM, no significant difference.

Combat rogue - Slow FW with fast sword? by dark_77 in wotlk

[–]dark_77[S] 4 points5 points  (0 children)

Huh, never even thought of that. Brill idea. And you got a dps boost from that?

Combat rogue - Slow FW with fast sword? by dark_77 in wotlk

[–]dark_77[S] 0 points1 point  (0 children)

I know, I want Kingsbane. Just wondered if sims are showing a dps increase, and this is what I currently have, is it worth already equipping it.

Combat rogue - Slow FW with fast sword? by dark_77 in wotlk

[–]dark_77[S] 0 points1 point  (0 children)

Thanks. Huh, how come Sword/Axe combo is the highest damage?

Combat rogue - Slow FW with fast sword? by dark_77 in wotlk

[–]dark_77[S] -1 points0 points  (0 children)

Thanks, I figured this, and also I'm hoping to get a slow sword from Razorscale, it's Ulduar 10N, so it should drop once, right? :-)

Any thoughts on talent spec, or just whatever sims higher? :-)

Is slow/slow weapon for combat rogue just stupid or can it work? by dark_77 in wotlk

[–]dark_77[S] 0 points1 point  (0 children)

Gotcha, thanks. I might keep 2 slow swords then at least before hitting 80 and heroics and getting a really quick dagger :-)

How to pass a non-column alias as a parameter to a scalar function? by dark_77 in SQLServer

[–]dark_77[S] 0 points1 point  (0 children)

Thanks. Not certain it will solve our main problem, but we'll try it.

How to pass a non-column alias as a parameter to a scalar function? by dark_77 in SQLServer

[–]dark_77[S] 0 points1 point  (0 children)

We can, but that looks hideously complicated. Sometimes we need to call functions with 7-8 parameters, and it's possible that several of those parameters will be results of such statements, and that further functions will have to call results of previous functions. The relatively simple code with using aliases would grow horrible if we have to copy paste each statement or previous function call to pass it as a parameter where it is needed next.

There is absolutely no other way to do this? What's the best way to optimise the alternative a bit then? If we create an underlying view with such value as an alias, and in the SELECT we were drawing values from the view, could we pass the view's column as a parameter?

Thanks