SQL Server Monitoring: What queries should you monitor?
I previously wrote about measuring wait statistics. This matters a lot, because you can track historically what wait statistics are...
2019-02-02
299 reads
Arthur's Blog
How many plans are in the plan cache for a stored procedure?
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
267 reads
Index maintenance freebies
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
2019-02-20 (first published: 2019-01-30)
2,398 reads
Query tuning: The IN clause
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
1,270 reads
My alternative to sp_WhoIsActive
I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...
2019-01-28
3,507 reads
Memory Grants part 6: Memory used in aggregate functions (Min/Max/etc)
So far in this series, I’ve been focusing on the Sort operator. It’s pretty easy for demos since I can...
2019-01-25
501 reads
The Execution plan comparison feature (in SSMS)
Did you know that you can compare two execution plans in SQL Server Management?
It’s really cool. I use it a...
2019-01-25
974 reads
It’s always parameter sniffing (Part 2): SET options
This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...
2019-02-14 (first published: 2019-01-23)
2,497 reads
Memory Grants part 5: Query hints
Proceed with caution, if you’re thinking of using query hints. This post will specifically cover min_grant_percent and max_grant_percent.
My opinion on...
2019-02-11 (first published: 2019-01-22)
7,086 reads
Memory Grants part 4: The Resource Semaphore
Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...
2019-01-21
581 reads
Blogs
Executing One Line in VSCode–#SQLNewBlogger
By Steve Jones
I wrote about arrays in PowerShell last week, but I realized one of the...
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Forums
Lake Database Performance Optimization
I recently created a synapse link for Dataverse. The resultant Lake Database in Synapse...
Selecting from a view, base table has a DENY on a column
This is something I've never seen before and I can't think of the right...
JSON data with Pivoted
Hi All, I need some assistance and not sure how to achieve the expected...
Ask SSC