Jared Poche

SQL Server engineer and educator since 2003. Database Engineer for ChannelAdvisor. Anime and pizza enthusiast. Blogging at

[Jared Poche @SqlJared]

This is likely my last post on this platform. I don't want to be part of what it is now. I'll keep up my previous posts, but you can find me on other social media locations like bsky going forward. #sqlfamily #sqlblog

[Jared Poche @SqlJared]

#sqlfamily, consider upvoting this feedback to add a filter for an object id\name in Query Store. This will help make variant queries from Parameter Sensitive Plan Optimization more visible and allow us to see a procedure's activity in one view. https://t.co/GVxhbMyk4I

[Jared Poche @SqlJared]

Anyone interested can email me at [email protected] if they can't message me directly.

[Jared Poche @SqlJared]

If anyone in #sqlfamily needs an invite to the other place, let me know. I'm hoping the community continues going in that direction.

[Jared Poche @SqlJared]

@erikdarlingdata "Was editing a row via Views->Create a view" But, wait. What? No!

[Jared Poche @SqlJared]

I've posted a new blog on PSPO at https://t.co/dpNtAlXTbD. This blog has links for a known issue, updates a previous script using sys.query_store_query_variant, and discusses PSPO plans with multiple variables. #sqlfamily #sqlblog

[Jared Poche @SqlJared]

@SQLBek I'd love one if there are any left.

[Jared Poche @SqlJared]

@grrl_geek @chapmandew You have my full attention with this arcade that serves beer.

[Jared Poche @SqlJared]

@GFritchey @SQLMCT That's pretty scary.

[Jared Poche @SqlJared]

I've posted a second blog about PSP Optimization at https://t.co/vOf8R8MbvP. Check it out to see why you may need to update your Query Store scripts for #SQLServer2022. #sqlfamily #sqlblog

[Jared Poche @SqlJared]

My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at https://t.co/75gvKhv0Zl. My next post will be on this subject as well, discussing an issue that may affect your Query Store scripts! #sqlfamily #sqlblog

[Jared Poche @SqlJared]

@erinstellato There are videos of millennials trying to use rotary phones that are hilarious.

[Jared Poche @SqlJared]

@crashdan I'd be happy to do a remote talk for a new user group.

[Jared Poche @SqlJared]

@ChrisHyde325 @erinstellato I had no idea...

[Jared Poche @SqlJared]

Posted a new blog about Manual Halloween protections and how this coding technique can allow you to skip unnecessary write operations at https://t.co/h5enDCYPg0. #sqlfamily #sqlblog

[Jared Poche @SqlJared]

Found an issue with one of my examples, so I added an addendum and updated the conclusion. Thanks to @SQL_Kiwi for pointing out that the compatibility level in WideWorldImporters is 130 by default.

[Jared Poche @SqlJared]

My latest blog on the Halloween Problem is up at https://t.co/6p2dJ1xMn5. Complete with examples showing the typical protections and some performance numbers. #sqlfamily #sqlblog

[Jared Poche @SqlJared]

@GFritchey Hence, scary dba.

[Jared Poche @SqlJared]

My latest blog on tempdb contention is up at https://t.co/Cz1cCy4Aez. I discuss improvements that minimize its effects and have several useful links on the subject. #sqlblog #sqlfamily

[Jared Poche @SqlJared]

@SQLEspresso Motivation varies, but cute corgis are forever.