Tweet

This Thread may be Removed Anytime!

Twitter may remove this content at anytime! Save it as PDF for later use!

More from @sqL_handLe

L_ N___

@sqL_handLe

12 Jan

trying to reproduce a system issue that presents itself in a complex ETL when run at full scale on a given system is tough.
but it’s a task i can do sometimes, and want to be able to do more often.

it’s an important task bc attaching a debugger to production is risky. and extended events is of limited use when some system symptoms are known but query/worker/memory condition contributors aren’t.

the rules of the game: i almost never get to work with the production system itself. can supply some low-impact information gather/logging tools.
probably won’t be able to work with production data in nonprofit database, either.

Read 38 tweets

L_ N___

@sqL_handLe

12 Jan

i still can’t separate Bill Cosby from Cliff Huxtable.
doesn’t just keep me from watching the Cosby Show; keeps me from referencing some great scenes from the show i think many people my age know well.
that’s a shame, especially considering all the other talent & people involved.

When Denise made Theo that “cool” shirt?! 🤣

Even when Theo dumps his heart out(although not fully on the up-and-up) to his dad, saying “i’m not like you and i just wish you’d accept me for who i am!?”
that was good stuff.

Read 4 tweets

L_ N___

@sqL_handLe

12 Jan

the idea for today is to cause #sqlserver [total server memory] to exceed [target server memory] by several gb with a rowstore-only workload and *then* read columnstore segments into buffer pool (and column store object pool).

while there are no columnstore related pages in bpool and columnstore object pool does not exist, the impossibly-high [target pages] value means almost no SQLOS free memory on the system.

initializing column store object pool brings [target pages] to a value well under [target server memory (kb)] - though, note [target pages] is measured in 8kb pages.

Read 5 tweets

L_ N___

@sqL_handLe

12 Jan

meaningful use of a 3d graph (rather than stacked/layered/mixed line + area 2d graph) would be unlocking a whole new achievement for me.

my imagination is so thoroughly 2d-based. i can imagine 2d objects in motion: waves, gears, spinning plates. But 3d is a problem for me.

my 17 yro daughter took a wood shop class maybe two years ago. she made a small puzzle cube - four, maybe five pieces.
took it apart in front of me. Put it together. Took it apart and gave me the pieces.
i tried for 30 minutes and couldn’t make a cube again 🤣

Read 5 tweets

L_ N___

@sqL_handLe

12 Jan

Y’all. in your 3 am glitter adventures, please only enter when invited; and don’t break any windows. Be like glitter vampyres, k?

but… look at those smiles. i kinda wanna hear their story.
~~
Women arrested after throwing glitter at man
2022 January 11
fox13news.com/news/clearwate…

i want to know if the coppers followed a glitter trail to their still-warm car. (according to the police the car was still warm, and glitter was found in the car.)
i also wanna know if those mugshots were from this incident or priors 🤣

What i’m sayin’ is, as long as my kids follow the rules (no B&E, no substantial battery, glitter can’t still be in the container when they throw it), if they get arrested for a glittering… i’ll be good for bail/bond with a quickness.

Read 6 tweets

L_ N___

@sqL_handLe

12 Jan

when do the stories people believe about a work of art, regardless of artist intent or history of the piece, become a part of the work of art?
i don’t know.

working with a database engine, i’m an absolute stickler for “design intent” as revealed by documentation and historical development.

i have a particular view of RDBMS cpu scheduling and memory management: unless documented otherwise (in detail with boundaries), if an user query workload with no external calls makes the system unresponsive due to cpu or memory saturation, it’s a bug.

Read 7 tweets

Share this page!

L_ N___

Try unrolling a thread yourself!

More from @sqL_handLe

L_ N___

L_ N___

L_ N___

L_ N___

L_ N___

L_ N___

Did Thread Reader help you today?

Like this author's thread?