Finding single use plans in the plan cache
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,924 reads
Blog Posts
Writing my presentation part 1: The brainstorm/dump
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
400 reads
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
What’s Global Azure Bootcamp?
The website says it best
…. communities will come together once...
2019-03-06
302 reads
Canadian SQL Saturday speaking events
I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of...
2019-03-06
280 reads
How to get Live Execution Plan using Extended Events
Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...
2019-03-06 (first published: 2019-02-19)
6,862 reads
How Your Hypervisor Can Impact Your CPU
Recently I had a client complain of chronic high CPU utilization. The performance of their SQL Server had degraded, and...
2019-03-06
584 reads
Midlands #PASS April Meeting with Matt Gordon (@SQLatSpeed)
Midlands PASS in Columbia, SC, will be hosting Matt Gordon (website | twitter) for our next meeting, which is scheduled for...
2019-03-06
269 reads
Pushing SQL Change Automation Code to Azure DevOps
Making changes on your own system for a SQL Change Automation project is great, but if you’re the only one...
2019-03-06
826 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-03-06
17 reads
SQL server reports GUI Schema change history and CPU RAM IO
SQL server reports GUI Schema change history and...
[[ This is a content summary only. Visit my website for full links,...
2019-03-06
423 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers