I just enabled page compression for all of the databases on a SQL 2022 SE server and DBCC CHECKDB has gone from 2 hours to 5 hours. I've never noticed this before. Has anyone else? Old slow spinning disks #sqlhelp
1
0
0
87
@MSSQLServerDBA In se dbcc checkdb runs single threaded (not sure if you can change that). When I’ve enabled page compression the trade off against less physical io is cpu usage. I’m guessing you are consuming a single cpu and bumping up against the limit of what that one cpu can do.
1
0
0
28
mysql pros, I need you
how can I make it read fewer rows?
there's already an index on `id`
how can I make it read fewer rows?
there's already an index on `id`
101
3
314
210,614
@chronark What’s the data type on id. You’re forcing it to a character data type by putting the value in quotes since the data types might not match
1
0
0
1,216
@chronark If it is an int data type take the quotes off and it should pick up the index
0
0
0
28
Bunch of Mac Lifers insisting that macOS is “just better” than Windows and I’d love to see their working.
What, exactly, makes macOS better? Because I find it clunky and awkward.
C’mon, @ me.
What, exactly, makes macOS better? Because I find it clunky and awkward.
C’mon, @ me.
Mac developers have been patiently waiting when Apple will finally ship either a touchscreen Macbook, or allow the Mac OS to run on iPads (making them a portable Macbook alternative)
Apple has not done it: but Microsoft has. And it's supposedly a more capable machine than a Mac:
637
28
953
741,689
@markrendle Mac OS is a bit clunky. I have to install third party software for window tiling and a volume mixer? Wut.
But at least I can close the laptop lid and it really suspends, instead of waking back up in my bag and cooking itself in the process like every Windows laptop ever.
But at least I can close the laptop lid and it really suspends, instead of waking back up in my bag and cooking itself in the process like every Windows laptop ever.
7
1
92
5,388
@booler @markrendle Did it to me and it was never the same after. Brand new laptop I bought and it committed suicide. During covid I had nowhere to go to show them the trash they sold me.
0
0
1
373
Every Twitter/x post I see is a question. Nobody just says what’s on their mind. Only people with good content seem to do that. If the post starts with what/how/who/why I scroll on now.
0
0
0
51
@natmiletic At starting windows of course.
1
0
4
3,124
@htmleverything @natmiletic M chips wouldn’t open my windows vm images. Took that right back to the store when I figured this out.
0
0
0
23
@SQLGrease oh well now, maybe true!
also seems to me you might be most proficient in maintaining performance monitoring tools for Microsoft SQL server?
ahh, i remember using IIS back in the day, thank you Microsoft and thank you SQLGrease 🙌
also seems to me you might be most proficient in maintaining performance monitoring tools for Microsoft SQL server?
ahh, i remember using IIS back in the day, thank you Microsoft and thank you SQLGrease 🙌
1
0
0
31
👋👋 I bet most founders making $1K/m can easily get a job for $100K/year if they are serious at it.
But still these founders chose $1K/m and take a chance.
Do you prefer taking chances?
Or do you prefer safe bet with full-time job and side project?
But still these founders chose $1K/m and take a chance.
Do you prefer taking chances?
Or do you prefer safe bet with full-time job and side project?
15
1
30
3,766
@upen946 I don’t consider starting a company a side project. If you’re being real about it you dive in head first and commit. It’s not always that easy financially but end game should be that what you’re building will be a real company.
1
0
0
38
If you could experience any video game for the first time again, what would it be?
464
16
220
116,120
Today is one of those days where I just can't get started.
I can't decide on what to work on.
The path isn't clear.
What do you do on these days?
I can't decide on what to work on.
The path isn't clear.
What do you do on these days?
145
1
136
36,483
@fraserdeans I make a list. I do the easiest thing on it first and check it off. After I get motivation to keep going.
0
0
0
40