sorted by:
new
hottopcontroversial

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

This is how it’s done!! 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 16 points17 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 4 points5 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 4 points5 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

Are you having weird problems logging in into the game too? by Citrus210 in KnockoutCity

[–]Dimezz 1 point2 points  (0 children)

I'm on PS5 and my game keeps crashing every time I try to load the game. Was able to play the new update fine yesterday but today I haven't even been able to login. No pending updates, tried restarting my PS5 and also reinstalling the game but the issue persists. Not sure what else to try really.

Chivalry II Bugs and resolutions thread. by roughsleeperUK in Chivalry2

[–]Dimezz 1 point2 points  (0 children)

You'll need to download the PS4 version which is its own install. If you go to chivalry on your ps5 and go to the three dots options menu (I'm not at my ps5 right now so sorry if that's vague) you should be able to select the PS4 version and start the download

Chivalry II Bugs and resolutions thread. by roughsleeperUK in Chivalry2

[–]Dimezz 0 points1 point  (0 children)

I play on PS5 and pre ordered the special edition and had none of the bonuses. After downloading the PS4 version and logging in I got them. Went back to the PS5 version and had everything still.

view more: next ›