Jared Poche
@SqlJared
Followers
98
Following
150
Media
1
Statuses
169
SQL Server engineer and educator since 2003. Database Engineer for ChannelAdvisor. Anime and pizza enthusiast. Blogging at https://t.co/Pl80KrD2WC.
Cary, NC
Joined October 2015
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
0
0
0
#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.
0
0
0
If anyone in #sqlfamily needs an invite to the other place, let me know. I'm hoping the community continues going in that direction.
2
0
0
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
sqljared.com
0
0
0
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
sqljared.com
In this post, I'll discuss on issue with variant queries in Parameter Sensitive Plan Optimization and how you may want to update your Query Store scripts!
0
0
0
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
sqljared.com
Parameter Sensitive Plan Optimization is an interesting new feature in SQL Server 2022. Let's review and look at a potential issue.
0
0
0
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
sqljared.com
What is the Manual Halloween technique, how does it work, and where is this an advantage? I'll explain with some examples in this post.
0
0
0
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
sqljared.com
Another post on the Halloween Problem with more concrete examples, specifically showing how index movement is an important part of the problem.
1
0
0
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
sqljared.com
Tempdb contention has been a well-known issue in SQL Server for a long time. If you aren't aware of the changes in the last several releases, read on.
0
0
1
Posted my last blog about being an introvert at #PASSDataCommunitySummit and how I approached the networking opportunities there at https://t.co/C7GbfFW1ew. Happy new year, #sqlfamily! #sqlblog
sqljared.com
A post on my recent experience of dealing with introversion at PASS Summit and some thoughts on making the most of opportunities at a major conference.
0
1
5
The conversations at #PASSDataCommunitySummit last week might have been the best part. Thanks to everyone in #sqlfamily for being so helpful and positive. Way too many to list.
2
0
6
Thanks to everyone who attended my session at #PASSDataCommunitySummit. I've updated my slides and demos, and the updated versions should be available for download shortly.
0
0
0
Posted my last blog, a foundational post on merge joins at https://t.co/E1rcrqBNJ9. Likely to post another comparing the three join types soon. #sqlserver #sqlblog
sqljared.com
A merge join can be the most efficient join used by SQL Server, but it comes with some asterisks. Read this to see how they work and what to watch out for.
0
0
0
Our next event is live and on Thursday, August 18th at 12 noon EST with @CindyGross called "Stepping Stones from Diversity Learning to Equitable Actions". Come join us for the must see presentation around #DEI efforts. https://t.co/CIQx16U8e8
0
11
5
I'm happy to be speaking at #PASSDataCommunitySummit this fall. I'll be presenting on "Maximizing Performance with Memory Optimized Table Variables", and I'm looking forward to seeing everyone in Seattle! #sqlfamily #sqlpass
1
0
8
My latest foundational blog on hash match joins is up at https://t.co/QOno58rdDX.
sqljared.com
A description of how hash match join operators function, what their advantages are, and why they probably aren't as bad as you've heard.
0
0
0
Finished a foundational blog on nested loops at https://t.co/kKqoKcpae4. Have a good weekend everyone.
sqljared.com
Nested loops are the join operator you will see most of the time with SQL Server. Let's explore how they operate, and what makes them efficient.
0
0
0
My latest blog on the QDS Toolbox is up at https://t.co/NMOYP1mv5a. These procedures make it easy to find significant changes to waits in Query Store. #sqlserver #sqlblog #querystore
sqljared.com
The Waits Variation procedures in the QDS Toolbox help identify changes which queries have had big changes in their wait times.
0
1
1