What Data Is Being Sent Externally By Power BI Visuals?
As you build your Power BI reports, you may want to use maps and custom visuals. Have you thought about...
2019-02-28
57 reads
Blog Posts
A short guide to sp_executesql
Last week I talked about single use plans. One way to increase execution plan re-use is to parameterize queries by...
2019-02-27
2,320 reads
Dem queries
Dem queries, dem queries, dem slow queries,
Dem queries, dem queries, dem fast queries,
Dem queries, dem queries, dem big queries,
Now write...
2019-02-27
1,152 reads
Editorial – Dealing with Ugly Babies
One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments....
2019-02-27
249 reads
Partitioning 1: Non-partition aligned queries
Here’s my take on partitioning. I’ll be focusing on getting queries to perform on partitioned tables, and not on partition...
2019-02-27 (first published: 2019-02-11)
2,506 reads
Proposed SQL Server defaults: disable priority boost
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-27
454 reads
Query Store and a READ_ONLY Database
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The...
2019-02-27 (first published: 2019-02-11)
2,098 reads
Using Github as a repository for SQL Server Helm Charts
In a previous post I ran through how to create a custom SQL Server Helm chart.
Now that the chart has...
2019-02-27
422 reads
Why i choose to use memory optimized table in MS SQL Server in some circumstances
MSSQL SERVERI was supporting an application which will be making a lot of concurrent calls to the database. The application which will be widely used and it will be...
2019-02-27
16 reads
Why i choose to use memory optimized table in MS SQL Server in some circumstances
MSSQL SERVERI was supporting an application which will be making a lot of concurrent calls to the database. The application which will be widely used and it will be...
2019-02-27
35 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