@SqlJared profile picture
Jared Poche @SqlJared

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

Joined October 2015
  • Tweets 169
  • Following 56
  • Followers 96
Photos and videos
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
28
Jared Poche@SqlJared
27 Nov 2023
#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. feedback.azure.com/d365commu…
133
Jared Poche@SqlJared
31 Oct 2023
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
131
Anyone interested can email me at sqljared@outlook.com if they can't message me directly.
1
52
I've posted a new blog on PSPO at sqljared.com/tag/parameter-s…. 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

Parameter Sensitive Plan Optimization, SQLJared

sqljared.com
46
I've posted a second blog about PSP Optimization at sqljared.com/blog/variant-qu…. Check it out to see why you may need to update your Query Store scripts for #SQLServer2022. #sqlfamily #sqlblog

Variant Queries in Query Store - sqljared

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!

sqljared.com
142
Jared Poche@SqlJared
27 May 2023
My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at sqljared.com/blog/parameter-…. My next post will be on this subject as well, discussing an issue that may affect your Query Store scripts! #sqlfamily #sqlblog

Parameter Sensitive Plan Optimization - SQLJared

Parameter Sensitive Plan Optimization is an interesting new feature in SQL Server 2022. Let's review and look at a potential issue.

sqljared.com
237
Jared Poche@SqlJared
20 Apr 2023
Posted a new blog about Manual Halloween protections and how this coding technique can allow you to skip unnecessary write operations at sqljared.com/blog/manual-hal…. #sqlfamily #sqlblog

The Manual Halloween Technique - SQLJared

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.

sqljared.com
39
Jared Poche@SqlJared
23 Feb 2023
My latest blog on the Halloween Problem is up at sqljared.com/blog/halloween-…. Complete with examples showing the typical protections and some performance numbers. #sqlfamily #sqlblog

The Halloween Problem Addendum on Update - SQLJared

Another post on the Halloween Problem with more concrete examples, specifically showing how index movement is an important part of the problem.

sqljared.com
1
50
Jared Poche@SqlJared
14 Mar 2023
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.
1
31
Jared Poche@SqlJared
31 Jan 2023
My latest blog on tempdb contention is up at sqljared.com/blog/tempdb-con…. I discuss improvements that minimize its effects and have several useful links on the subject. #sqlblog #sqlfamily

Tempdb Contention in 2023 - sqljared

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.

sqljared.com
1
64
Posted my last blog about being an introvert at #PASSDataCommunitySummit and how I approached the networking opportunities there at sqljared.com/blog/introversi…. Happy new year, #sqlfamily! #sqlblog

Introversion and PASS Summit - sqljared

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.

sqljared.com
1
5
1,678
Jared Poche@SqlJared
21 Nov 2022
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
6
Jared Poche@SqlJared
21 Nov 2022
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.
Jared Poche@SqlJared
11 Oct 2022
Posted my last blog, a foundational post on merge joins at sqljared.com/blog/merge-join…. Likely to post another comparing the three join types soon. #sqlserver #sqlblog

Merge Join Operator - SQLJared

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.

sqljared.com
Jared Poche retweeted
Data Platform DEI Virtual Group@data_dei
8 Aug 2022
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. bit.ly/3A2Rh8n
11
5
Jared Poche@SqlJared
16 Jul 2022
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
8
My latest foundational blog on hash match joins is up at sqljared.com/blog/hash-match….

Hash Match Join Operator- SQLJared

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.

sqljared.com
Jared Poche@SqlJared
30 May 2022
Finished a foundational blog on nested loops at sqljared.com/blog/nested-loo…. Have a good weekend everyone.

Nested Loops Join Operator- SQLJared

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.

sqljared.com
Jared Poche@SqlJared
10 Feb 2022
My latest blog on the QDS Toolbox is up at sqljared.com/blog/qds-toolbo…. These procedures make it easy to find significant changes to waits in Query Store. #sqlserver #sqlblog #querystore

QDS Toolbox: Waits Variation - sqljared

The Waits Variation procedures in the QDS Toolbox help identify changes which queries have had big changes in their wait times.

sqljared.com
1
1
Load more