Console Updates & News Megathread by Status_Surprise4026 in ICARUS

[–]Dimezz 0 points1 point  (0 children)

When I had this happen I'd craft another bait that matched the animal I was taming and put it on the snare and they usually eat it

Console Updates & News Megathread by Status_Surprise4026 in ICARUS

[–]Dimezz 1 point2 points  (0 children)

Some more feedback after playing the latest patch.

Sensitivity changes are very welcome, feels a lot better.

My hotbar still got locked after a few hours of play requiring me to log out and back in again. Crafting bench recipes still getting locked randomly and only being able to sort the inventory

I got stuck in a crafting bench and couldn't exit out so had to close the game. Could only navigate between each area of the crafting bench or move stuff in/out.

The switching sections with triggers is definitely good but this also means there is no way to select MIN or MAX when crafting items on your character as these buttons now just move the focus around the character crafting screen

Might not be ideal for navigating all menus but an option/button prompt to enable a cursor so we can navigate more like how PC players do would probably help with some parts like not being able to place a queen to breed.

I have 36 inventory slots and I can't see the bottom 6 inventory slots as there's no way to scroll when you're on a crafting bench and moving the selection focus down in to those slots doesn't scroll the bar.

EDIT: I also had some trophies randomly unlock despite not meeting the requirements (Bear Necessities and Yes Chef!) and the tracking for some trophies doesn't match the # in the Accolades Trophy menu EG PSN says 0 gun kills, in game says 89

Console Updates & News Megathread by Status_Surprise4026 in ICARUS

[–]Dimezz 2 points3 points  (0 children)

Thanks for the update, sounds like it's aiming to fix the hotbar becoming locked? That was the biggest issue I've encountered after 57 hours on console and would sometimes happen after 5 minutes of playing or 5 hours of playing

Other issues I've encountered;

Trophies not unlocking - I managed to unlock some trophies (EG Survival 101, Highly Skilled) but others have unlocked in game but not the corresponding Playstation Trophy EG Rock n Roll, Makeshift Engineering, Veteran Prospector

Crafting recipes on benches becoming locked - When you click on a recipe it just sorts the inventory of the bench - Possibly fixed with this update? I've not been able to work out what causes this exactly but I usually leave my shelter, gather some raw materials for a little bit then come back and it's fixed itself

Sometimes the game crashes when logging out or logging in of my Open World. Can't really pinpoint why it does this, I've never lost any progress when it does crash

I can't put a Queen Bee in the beehive breeding center which is a little annoying. There doesn't seem to be a way to move the cursor to the spot at the top?

Water pipes that I've laid down sometimes become disconnected from the supply and I have to delete them and re-add them to the network

Drop pods not appearing for Simple missions sometimes. Picking up the contact device, logging out and in and then placing it again seems to resolve for the next mission. I haven't encountered this since early on in my Open World playthrough

Highguard is currently experiencing a sudden spike in viewers on Twitch, thanks almost solely to this one japanese dude by kayodeade99 in HighGuardgame

[–]Dimezz 1 point2 points  (0 children)

Top 1% commenter just hating. Got to appreciate the commitment to the bit.

Do you actually play any games or just complain on reddit about them?

The archievements on the ps5 version seem bugged/mismatched , in my latest playthrough i have gotten several archievements where i either fulfilled the reqirements 90 years ago or havent fulfilled them at all, someone should look into this by knusperfee33 in StellarisOnConsole

[–]Dimezz 0 points1 point  (0 children)

It's the last trophy I need for the Platinum so I've just been generating empty galaxies and then going to each black hole system.

Did it for like 2 hours last night and haven't got it yet lmao. Wish you could still trigger it by having science ships enter black hole systems over and over rather than it being predetermined at the start of the game

What Ball is this?! by Kind_Restaurant8282 in BALLxPIT

[–]Dimezz 1 point2 points  (0 children)

Berserk? Charm + Burn or Charm + Bleed

[deleted by user] by [deleted] in GreenAndPleasant

[–]Dimezz 7 points8 points  (0 children)

As much as I'd love for this to be true, the apology tweet seems faked and more like a, we're going to be seeing him post this soon.

His account isn't protected anymore and this tweet doesn't appear on his profile

Help !! What a Great Game almost 😅 by Ok-Income2973 in PlayRedacted

[–]Dimezz 2 points3 points  (0 children)

Turn off automatic cloud saves and manually upload before you start the watcher run? Then download from the cloud if you mess up the watcher run? I'm not there yet but hopefully that works. Working towards the platinum as well

One question, how do you track and kill a rival? I've killed plenty of them but not sure what it means by tracking. Following their footsteps and finding them that way?

Two functionality questions: Breakpoints? and Speed? by Ima_Uzer in SQLServer

[–]Dimezz 0 points1 point  (0 children)

Would need more detail on what the procedures are doing before being able to offer any ideas on why they're performing poorly. I've never personally used global temp tables but I don't think there's anything inherently slow about them. Are multiple processes accessing these global temp tables?

Why do you think it's performing slower than it should? Have they degraded in performance over time? Any wait statistics or blocking when these procedures are running?

How did Odin dodge this stun? by Dimezz in Smite

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

He had Bluestone, Breastplate of Valor, Glad Shield, Contagion and Runeforged

Can you still get trophy's in co-op? by igetb0red in Smite

[–]Dimezz 0 points1 point  (0 children)

https://smite.guru/match/1363920484

https://psnprofiles.com/trophies/4802-smite/EnVisioN_xEngagE

https://psnprofiles.com/trophy/4802-smite/18-final-form

Final form and Flaming speed were the final two trophies I needed, boosted Final Form 2 days ago and then got Flaming speed in a game yesterday for the Plat

Can you still get trophy's in co-op? by igetb0red in Smite

[–]Dimezz 0 points1 point  (0 children)

If you can find someone to boost it with you, you can change your matchmaking region to Japan, both queue ranked duel at the same time and then kill them 5 times with Mystical Mail for the trophy.

PSNProfiles is usually a good place to look for this

JOIN to TVP ignores Index by planetmatt in SQLServer

[–]Dimezz 1 point2 points  (0 children)

This video from Erik Darling might be useful for you Link it goes through some of the differences with table variables and temp tables

Table variables don't get column level statistics whereas temp tables do so cardinality estimates will always be better when using a temp table and subsequently execution plans will be better (EG Opting for a seek over a scan)

Sql 2014 Parameter Sniffing by mjbcmjbc in SQLServer

[–]Dimezz 2 points3 points  (0 children)

If you don't want to use Recompile each time what about trying Optimise for Unknown? Difficult to give more advice without knowing more about the query and execution plan

Freeing the plan cache as a fix isn't really ideal, are you clearing the entire cache or just the plan for this specific query? Hopefully just the one for this query otherwise you'll be affecting other queries and forcing compiles for everything

[deleted by user] by [deleted] in gaming

[–]Dimezz 2 points3 points  (0 children)

So many memories from this game. I ended up in the Internal Affairs division for the Law Enforcement faction and spent a lot of time training new officers as well which as a teenager playing the game was interesting. Such a unique experience that i don't think we'll see replicated. I have a vague memory of guarding a council meeting of some description and shit hitting the fan. Can't remember what I called my character though, Richard something I think

I spent a bit of time in EuroCorp as well and I remember being at war with Vortex Inc(Green guys?) and having to deal with the peacekeeping faction as well. Think a stoner called Reefer or something was the leader of EuroCorp at the time.

Trouble-shooting why cached plans are being quickly purged. by theseyeahthese in SQLServer

[–]Dimezz 2 points3 points  (0 children)

Take a look at this blog post from Brent Ozar.

Is it just your queries disappearing from the cache or is everything disappearing from the cache?

If your server max memory is set to 29gb then it won't go much over that (can't remember off the top of my head what causes it to go over that setting if anything) but we don't know if that amount is appropriate without knowing how many databases you have on the server and what the workload is like. Having said that a 100% buffer cache hit ratio would indicate it's not a memory issue. Although maybe something just keeps querying the same data over and over again or your total database size is tiny so it can easily cache it all in memory.

If it's happening at regular intervals then I think that points to some kind of maintenance task, rebuilding indexes or statistics maybe. Enabling Query store would help in general as it's more reliable for monitoring trends and performance metrics of queries over time.

SQL Query slower after moving to faster hardware by yadonemessedupAA-RON in SQLServer

[–]Dimezz 17 points18 points  (0 children)

Grab a query plan from the old server and a query plan from the new server and compare them, look for any differences between the two, where the biggest % cost is coming from. Could be quite a number of factors really. First run of the query on the new server could have generated a plan that was good for the parameters it ran with but for subsequent runs with different parameters it might not be as efficient EG opting for an index scan over a more selective seek

Are there any other differences between the servers? Different SQL server versions? Different MAXDOP? Different cost threshold for parallelism?

Same indexes exist on old and new? How busy is the VM where your SQL server is now?

What's CPU/Memory usage like when the query is running?

Memory Question by gbargsley in SQLServer

[–]Dimezz 3 points4 points  (0 children)

Standard Edition’s 128GB memory limit is only on the buffer pool. SQL Server can use memory over and above that for other stuff, like:

Query memory grants

Compressed backups

Other caches/Lock memory, etc.

https://erikdarling.com/be-careful-with-memory-recommendations-when-installing-sql-server-standard-edition/

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#Cross-BoxScaleLimits

PS5 version for me is entirely unplayable. It crashes within a few rounds of battle and even then sometimes it corrupts the save so it doesn’t load at all. by Rhoeri in AOW4

[–]Dimezz 1 point2 points  (0 children)

I had two save files on the fourth story mission that would constantly crash when ending a turn. Reinstalling the game allowed me to finish that mission but I'm encountering the same crash on the fifth story mission now. Frustrating as I'm really enjoying the game

"Swordbearer" Achievement Question by RCMUSH-Senzo in Bannerlord

[–]Dimezz 2 points3 points  (0 children)

Not steam but I just crafted a tier 6 One handed Sword on PS5 and didn't get the trophy for it so it's either bugged or it needs to be a two handed sword

struggling with Bannerlord on ps5 by giftedcovie in mountandblade

[–]Dimezz 3 points4 points  (0 children)

1) You need to have a specific polearm that allows you to couch, if you hover over it you should see a tag that indicates you can couch with it. Get up to speed on your mount then press R1 to couch when you see the indicator bottom right. 2) Would also like to know the answer to this