@SqlJared

SQL Server engineer and educator since 2003. Database Engineer for ChannelAdvisor. Anime and pizza enthusiast. Blogging at https://xitter.cf/t.co/Pl80KrD2WC.

 Cary, NC
Joined October 2015
  • Tweets169
  • Following56
  • Followers96
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
29
#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
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 [email protected] 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
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
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
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
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
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
1
5
1,678
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
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.
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
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
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
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
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