Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We...

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly so there is...

One week blogging hiatus

I’m taking a brief break from daily blogging, even though it has been a ton of fun.

No excuses
I hope...

Optimize for ad hoc VS sp_executesql?

Happy Friday! We made it. Here’s something I came across while testing optimize for ad hoc for this week’s blog...

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let's look into the performance gains this offers.
The post Scalar UDF Inlining in...

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let's look into the performance gains this offers.
The post Scalar UDF Inlining in...

Weekly reading #6

Coding Family is late this week with the blog post! It is due to heavy storms and wind! It started...

WIT Panel for Women’s History Month

I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...

Favorite community scripts and their parameters

Here’s some of my favorite community scripts and how I like to run them. If you haven’t tried the optional...